Get the minimum value of multiple variables

[webportal]

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.

Is there a better way?

Thank you!

[PhilipTreacy]

Hi @webportal 

Define empty!  If its an empty string then using MIN won't work as hoped and you mentioned MIN in the qs so assumed we were dealing with numbers.

It will discount BLANK values.

Phil

[webportal]

@PhilipTreacyExactly.

By empty, I mean ISBLANK(VAR) = True

[PhilipTreacy · Accepted solution]

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]

@PhilipTreacyThank you, that solution also disconsiders empty values, right?

[PhilipTreacy]

Hi @webportal 

Try this

Measure = 

VAR a = 3
VAR b = 4
VAR c = 2
VAR d = 5

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

RETURN MINX(tab,[Value])

Regards

Phil