6 Replies Latest reply: May 30, 2017 9:43 AM by Jonathan Ruiz

# Maximum period per year with expansion sign

Hello, I have this problem, when I apply a formula to the following years MonthName(Max(Periodo), it returns the last month of the year with data, which is correct, but doing so in this way '\$(=MonthName(Max(Periodo)))', brings me the total value, could someone help me, I need the Value in quotation marks for a set analysis  Thank you

• ###### Re: Maximum period per year with expansion sign

Hi Jonathan,

'\$(=MonthName(Max(Periodo)))' is evaluated once per chart.

Regards,

Antonio

• ###### Re: Maximum period per year with expansion sign

try without the equal sign

\$(MonthName(Max(Periodo)))

• ###### Re: Maximum period per year with expansion sign

Hi Jonathan,

The difference between the \$() expressions and the ones without \$() is that the first is evaluated globally, for the entire data set. The latter is evaluated for each row, thus is taking into account the dimensions used in the table.

Have a look at the attached file. Is not the best solution, but I hope it will provide you with some useful hints.

Regards,

David

• ###### Re: Maximum period per year with expansion sign

Thank you very much for your answer, it is very useful to solve the problem that I have, thanks David