Max Month order amount

[sspawar88]

Hi community,

Why following Expression is not showing result..is it any mistake in it?

sum({$<Month1={$(=max(Month1))}>}[Order Amount])

[crusader_]

Hi,

Check format of Month1.

Use simple listbox or textbox. In set analysis they must be the same.

I believe that Month1 is a text in your case.

Regards,

Andrei

[sspawar88]

Month1 is field for Months.

[crusader_]

Obviously, yes

Show me, please, the script code how do you create this field.

Regards,

Andrei

[sspawar88]

Year("Reported Date") as Year,

     Month("Reported Date") as Month1,

[kavita25 · Accepted solution]

Try this

=SUM({< Month1=, Month1={'$(=Maxstring(Month1))'}>}[Order Amount])

Regards,

Kavita

[sspawar88]

Miracle Miracle

what is Maxstring....

Fantastic

[crusader_]

Please add

, num(Month(Date)) as numMonth

in your script and use it for Set Analysis.

Regards,

Andrei

[kavita25]

Maxstring is used for String...

max is used for numeric values..

[sspawar88]

My answer is in 14.2588887 can you show me how to use num() to restict it on 14.25