Set Analysis Max Year, Month

[#1]

Hello,

I'm trying to do something that seems relatively simple but i cannot get it to work. I want to calculate the sum of a value only for the maximum year and month of the current selection. This is the expression i'm using,

sum({$<YEAR = {$(=max(YEAR))}, MONTH = {$(=max(MONTH))}>} Stock_Value_CY)

I;ve broken the expression in its compnenets and although the expression for max year works, the expression for max month doesn't.

Anybody can see what i;m doing wrong?

[PrashantSangle]

Hi,

Try in ""

like

sum({$<YEAR = {"$(=max(YEAR))"}, MONTH = {"$(=max(MONTH))"}>} Stock_Value_CY)

Regards

[MK_QSL]

Can you share your sample apps please?

[jyothish8807]

Hi Petrovic,

Your expression looks good , i think some issue with month field.Can you please share your app?

Try =max(MONTH) in a textbox and see what output you are getting?

Regards

KC

[#5]

I've already tried this syntax, it doesn't work.

[#6]

I've done this and it gives me back the value i want. it is numeric, integer btw.

I've also tried making the calculations into variables and use the variables but it still doesn;t work. A set analysis expression using the year variable works but the month doesn;t.

[#7]

I can't upload the app because I'm working on a document taken from the customer which is too big to upload. I do not have a smaller data set.

[#8]

try this

i guess u made field mistakes

sum({$<YEAR = {$(=max(YEAR))}, MONTH = {$(=max(MONTH))}>} Stock_Value_CY)

do u have the field called month in capital letters?

[ashwanin]

Hi Vasilis,

=max(year) provide you 2014 , while =max(month) provide you ' - '

Please add the field name from where you are taking the month

e,g =max(month(today()))

[#10]

These 2 fields are in capital letters and i've tried pasting the actual field names. The result is the same.