Forum Discussion

webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Get the minimum value of multiple variables

MyColumn = VAR1 = ... VAR2 = ... VAR3 = ... VAR4 = ...   I want to get the minimum value of all these variables excluding empty values.   MIN only takes two arguments.   Nesting is boring. ...
Need Help
Tips and Tricks
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi webportal 

    Yes it can handle that.

    Measure = 

VAR a = 8
VAR b = BLANK()
VAR c = 21
VAR d = 5

VAR tab = {(a),(b),(c),(d)}

RETURN MINX(tab,[Value])

     

    Regards

    Phil

webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
5 years ago

PhilipTreacyExactly.

By empty, I mean ISBLANK(VAR) = True

 

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi webportal 

Yes it can handle that.

Measure = 

VAR a = 8
VAR b = BLANK()
VAR c = 21
VAR d = 5

VAR tab = {(a),(b),(c),(d)}

RETURN MINX(tab,[Value])

 

Regards

Phil