Forum Discussion
Solved
IF statement using Measures
Hi,
I have 2 measures (apps_val and comps_val) of which I need to create a text output on based on the following logic. How would I correctly write this out please?
If apps_val > comps_val and comps_val > 0 then "uplift" else
If apps_val < comps_val and apps_val <>0 then "not required" else
If apps_val > 0 and comps_val is blank then "test"
Measure = If([apps_val] > [comps_val] && [comps_val] > 0 , "uplift",
If [apps_val] < [comps_val] && [apps_val] <>0 , "not required",
If [apps_val] > 0 && [comps_val] ==BLANK(), "test",0)
3 Replies
Algo igual o similiar a esto:
Salida = if apps_val > comps_val and comps_val > 0 then
"elevar más"
else if apps_val < comps_val and apps_val <> 0 then
"no es necesario"
else if apps_val > 0 and comps_val = null then
"prueba"
else
"otra salida"Measure = If([apps_val] > [comps_val] && [comps_val] > 0 , "uplift",
If [apps_val] < [comps_val] && [apps_val] <>0 , "not required",
If [apps_val] > 0 && [comps_val] ==BLANK(), "test",0)Hi M_SBS_6 ,
You can try the following:
Comparison = SWITCH( TRUE(), AND([apps_val] > [comps_val], [comps_val] > 0), "uplift", AND([apps_val] < [comps_val], [apps_val] <> 0), "not required", AND([apps_val] > 0, ISBLANK([comps_val])), "test" )If I answered your question, please mark my post as a solution.
Best,
