If statement with Min function

[younlim91]

Hello,

I'm trying to create a dimension like "if ((min(A,B)-C) > D, "N", "Y")". Please help! Thanks!!

[MayilVahanan]

Hi @younlim91 

Try like this

=if(RangeMin(A,B)-C > D, "N", "Y")

[younlim91]

It's giving me "Error in Expression" 

[tresB · Accepted solution]

@younlim91 

Try with single quotes, like:

=if(RangeMin(A,B)-C > D, 'N', 'Y')

[edwin]

are you creating the dimension in a chart or in the data model?

[younlim91]

I'm creating dimension in a chart

[younlim91]

It works! thank you so much!