August 3, 2005 at 6:52 am
There is a problem in my report i.e,
x and y is members
=sum((x/sum(y)))
this expression shows error.
either their is way to do that or
any function other than SUM() which add memebrs or work as sum function?
thankyou.
August 3, 2005 at 7:43 am
is this what you need?
=sum(x) / sum(y) ---make sure that the 2nd sum can't be 0
August 4, 2005 at 1:15 am
this is my Actual expression
=(Fields!Measures_Escrow_Float_Income.Value /sum(Fields!percentageEscrowFloatIncome.Value, "EscrowFloatIncomeDataSet"))*100
but if i use
=sum((Fields!Measures_Escrow_Float_Income.Value /sum(Fields!percentageEscrowFloatIncome.Value, "EscrowFloatIncomeDataSet"))*100)
than it will shows error
i am taking second sum because i want to show sum of that expression value column when plus in month column are not clicked.
how will i do this .
thanks for trying to solve My report problem.
August 4, 2005 at 2:08 am
I believe it's related to how/when the dataset set is used in the expression
I take it that this is a matrix report, you could have a look at "InScope"
=iif(InScope("matrix2_GRP1"), Sum(Fields!Income.Value), (Sum(Fields!Income.Value) * 100) / Sum(Fields!IncYearToDate.Value))
When the detail is displayed (InScope/Clicked) it will show the Total and when it's not it will show the Percentage (not clicked).
Robbie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply