Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I have a text box with this:
=date(Min({$<[délai_Kx_rest_du]={">365"}>} %KeyDate), 'MMM YY')
that gives me the max month used in the chart.
Now I would like to use this formula in a set analysis with date= this formula.
I cannot get any set analysis ok ?
Any suggestion ?
Hi Bertrand, you can try creating a variable with that expression, and use the variable value in set analysis:
DateFieldName={'$(variableName)'}
With an input box you can check the variable value. Working with dates can be tricky, maybe you are giving a number when in expects a text or viceversa.
Hi Bertrand, you can try creating a variable with that expression, and use the variable value in set analysis:
DateFieldName={'$(variableName)'}
With an input box you can check the variable value. Working with dates can be tricky, maybe you are giving a number when in expects a text or viceversa.
Does it give you max month of min month? I see the usage of Min() function.
Also, %KeyDate is in format MMM YY? or another format?
Is it max or Min?
Yes that's finally what I did and it works. Thanks a lot.