Hi ,
I have placed expressions in textboxes in footer of a tablix control
please look at my expressions:
Total In :=Sum((Fields!HardMeterInCurrent.Value-Fields!HardMeterInPrevious.Value),"SettlementDetailsDS")
Total Out: =Sum((Fields!HardMeterOutCurrent.Value-Fields!HardMeterOutPrevious.Value),"SettlementDetailsDS")
Total PayOut: =FormatPercent((Sum((Fields!HardMeterOutCurrent.Value-Fields!HardMeterOutPrevious.Value),"SettlementDetailsDS")\(Sum((Fields!HardMeterInCurrent.Value-Fields!HardMeterInPrevious.Value),"SettlementDetailsDS"))),0)
The result of Total In,Total Out,Total PayOut in should be displayed in the pdf report.Iam getting values of
Total In & Total Out but Total PayOut result is empty.Its not displaying anything.pls tell me solution immediately.
Note: Total PayOut=(Total Out/Total In)*100
Regards
suneethha