December2000
asked on
SSRS Expressions
How do you calculate RunningValue with (ReportItems!Textbox56.val ue) type of values.
The calculations are in decimal values and (ReportItems!Textbox56.val ue) calculation is = IIF((((Fields!UNITBIDAMOUN T.Value) <> 0 or (Fields!BILLINGQTY.Value)) <> 0) , (Fields!UNITBIDAMOUNT.Valu e) * ( Fields!BILLINGQTY.Value), 0)
The calculations are in decimal values and (ReportItems!Textbox56.val
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm not sure I understand your last question/statement, but you can use the Calculated Value as any other field defined in the Dataset.
ASKER
SSRS indicates that you can't use calculated fields for aggregates (ReportItems!Textbox56.val ue) is a sum of one field added to another.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you!
ASKER
I am sort of a newbie, Then I would use the RunningValue? I am trying to get the net value for the invoice but, I am getting the line value with the sum() expression.