Forum Discussion

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive Resident
2 years ago

Help 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