CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

IfThen(Condition, TrueParameter, FalseParameter) Retrives only the fales paramter ??

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 to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center