In a report I need to fetch data from GLHistory DAC, in my report table schema I have join GLAccount also. I need to get the sum of GLHistory.FinBegBalance where the Account Id is equal to 7000. for that I add variable and set its value base on a IIF condition. but it is not working.
Herewith I have attached my report, inside the details section I have define the variables. currently I have changed the if condition as bellow for debugging purposes
=IIf( [Account.AccountCD] = '7001',True, False)
I tried different ways such as
=IIf( [Account.AccountID] = 7001,True, False)
=IIf( [Account.AccountCD] = 7001,True, False) etc. but nothing works