Pick the max month end value

[Anonymous]

I have a calculated column lets name as sales,

I want to pick the Max value for the Month end dates. Need to find which month end date has highest value and month name.

[sunny_talwar]

Would you be able to share some sample data with expected output from the data that you provide?

[Anonymous]

I have calculated column g in my table chart now I need to find max and min month end values highlighted in yellow.

[sunny_talwar]

Is this something you need in the script or front end of the app?

[Anonymous]

Like in text object front end.

[sunny_talwar]

Do you want to sum the values highlighted in yellow? or average them? Since there are multiple values, how would you want to see them?

[Anonymous]

I want the sum highlighted in yellow since they are month end values.

I want to pick max and min of them

[olivierrobin]

hello,

to have the sum of the values,

first add tis expression in your load

if(date(TRANSACTION_DATE)=date(MonthEnd(TRANSACTION_DATE)),1,0) as LastDayofMonth,

it will determine if the date if ths last day of the month

then in a text box, use :

=sum(${<LastDayofMonth={'1'}>}MTD)

[sunny_talwar]

May be like this

Sum({<TRANSACTION_DATE = {"=TRANSACTION_DATE = Floor(MonthEnd(TRANSACTION_DATE))"}>}MTD)