ifThen condition issue in FR Reporting
Summary
IfThen(Condition, TrueParameter, FalseParameter) Retrives only the fales paramter!!Content
Hi all,
I'm using the below condition in formula column in FR:
IfThen([3, A] = [3, K], Sum([F],[G]), Sum([G]))
so i was expecting 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 false parameters what ever the result always Sum([G]) applied so is that working correct or any advise??
Regards,
Hussein
Tagged:
0