Help in expression to get the Total correct .

[ashmitp869]

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

[Ritaf1983]

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.

How to Get Your Question Answered Quickly  

[ashmitp869]

Hi @Ritaf1983 

This is Paginated Report .

here is link of sample.rdl file

https://github.com/suvechha/samplepbi/blob/main/sample.rdl