You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ifThen condition issue in FR Reporting

Question
9
Views
0
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!