Forum Discussion

M_SBS_6's avatar
M_SBS_6
Icon for Helper V rankHelper V
3 years ago
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 ...
Need Help
  • ddpl's avatar
    ddpl
    3 years ago
    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)
Alf94's avatar
Alf94
Icon for Solution Supplier rankSolution Supplier
3 years ago

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,