Forum Discussion
ashmitp869
Responsive Resident
2 years agoHelp in expression to get the Total correct .
Hi ,Please assist with the correct expression to achieve my requirement.
This is Paginated Report.
I have a calculation which does Project to Date Claim Total - Sum Billed Reveneue to get This Claim (Claim Total)
i,e $5742.85 - 5742.85 = ($0.01) which is correct.
Expression :
=Sum(IIf(Fields!BilledDate.Value >= Parameters!CalendarStartofMonth.Value AND Fields!BilledDate.Value <= Parameters!CalendarEndofMonth.Value, IIf(Fields!SumBilledRevenue.Value > 0, (Sum(IIf(Fields!PostedDate.Value <=Parameters!CalendarEndofMonth.Value ,
Fields!TotalCost.Value * 1.15,
0))) - (Fields!SumBilledRevenue.Value), 0), 0))My requirement is sum of Total show as
How to get the TOTAL in the below as ($0.01) ?
Thanks
2 Replies
- Ritaf1983
Super User
Hi ashmitp869
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
- ashmitp869
Responsive Resident