Tranform a formula in set analysis

[Anonymous]

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 ?

[rubenmarin · Accepted solution]

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.

[sunny_talwar]

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?

[shiveshsingh]

Is it max or Min?

[Anonymous]

Yes that's finally what I did and it works.  Thanks a lot.