using built in functions within set analysis

[#1]

Hi,

I have been tring to get the metric value for the current year and month being current month-1.

Below is the expression that i have used to acheive the same.But i am not getting any valid results

  =only({$<My_Year={'=$(=year(today())'},
My_Month={'=$(=Month(AddMonths(today(),-1))'}>}Value)

Can anyone let me know where i have gone wrong

[tresesco]

Two things come in mind:

1. If there are  more than one values for Value for current year previous month, ONLY() would return NULL

2. My_Month format may not be matching.

[jagan]

Hi,

If there are multiple values for Value dimension then you will get a null value, check this.  If there are multiple values then try using any max, min, sum functions.

Also make sure that My_Month and =Month(AddMonths(today(),-1)) are in the same format.

Hope this helps you.

Regards,

Jagan.

[#4]

I did try with sum even then i am getting Null as the result.I have attached thae sample application too so please have a look and let me know where i have gone wrong

[tresesco]

Attachment?

[#6]

Thanks & Regards,

Anushree Shetty

[tresesco · Accepted solution]

PFA,

It was parenthesis issue.