If Then Condition in Financial Reporting
Hello all,
I'm using the finacial Reporting in PBCS to generate report for LTM however i'm using the following condition:
IfThen([3, A] = [3, K], Sum([F],[G]), Sum([G]))
so i was excpecting if cell [3, A] equal cell [3, K] the the column will Sum([F],[G]) as it's the true parameter, and if cell [3, A] Not equal cell [3, K] then Sum([G]) will applied as the false parameter. but the issue is it always apply the fales parameters what ever the result always Sum([G]) applied so is that working correct or any advise to solve this ?
Thanks in advance
Hussein