Jes Sie

Jes Sie

  • 708
  • 1.2k
  • 264.3k

Aggregate in SSRS

Dec 8 2020 11:50 PM
I created an expression to sum all rows, please see below:
  1. =SUM(SWITCH(Fields!LAK.Value > 0, Fields!LAK.Value/ReportItems!ThbForex.Value, Fields!LAK.Value = 0, Fields!THB.Value))  
ReportItems!ThbForex.Value comes from a different dataset. But, when I run the report, it gives me the error below:
 
Can someone help me with this? Thanks.

Answers (1)