Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have defined a variable in variable field
where it says
name:vmaxmonthyear
defination:max(Date#([MONTH YEAR Calender]))
how can i use this in set anyalysis
Count({<[Calender MONTH]={"$(vMaxMonthYear)", >}[TXN UID])
May be like this:
Count({<[Calender MONTH]={"$(=vMaxMonthYear)"}>}[TXN UID])
or
Count({<[Calender MONTH]={"$(=$(vMaxMonthYear))"}>}[TXN UID])
Hi,
i think you only need to add the = sign as follows:
=Count({<[Calender MONTH]={"$(=vMaxMonthYear)", >}[TXN UID])
Please let me know if it helps.
Kind regards,
This is not working ,
Actually i have calculate maximum year and month , so that i cna show the latest month data .
My month-year column is like this
MMM-YYYY
i'm using variable
max(Date#([MONTHYEARCalender]))
Do you think this right???
This is not working ,
Actually i have calculate maximum year and month , so that i cna show the latest month data .
My month-year column is like this
MMM-YYYY
i'm using variable
max(Date#([MONTHYEARCalender]))
Do you think this right???
Plaese help
Hi Yogita,
what do you mean by not working?
Not giving the desired result? Returning Error in Expression?
Maybe you can share a sample app in order to give a more effective solution.
Kind regards,