Set expression

[#1]

Hi all,

i am using below set expression in straight table. It is not displaying any data why ?

=sum({<Year={$(=Only(Year)-1)}>} Sale)

Can anyone what is mistake in above expression ?

Thanks in advance

Regards

Venkat

[#2]

Venkat,

Probably there is no data for that year. Anyways what does this expression return Only(Year)-1?

If it returns null then try using Max Function.

Kiran

[#3]

Hi Kiran, first thanks to your response.

that returns null, so now i used the max function. Now it is working.

I tried below expression , it is not generating any value, and what is FirstSortedValue and why it is not generating any result ?

= Sum({<Year={$(=FirstSortedValue(Year))

Thanks in advance

Regards

Venkat

[#4]

= Sum({<Year={$(=FirstSortedValue(Year)) has only set analysis where is the field to be summed? Probably you are looking for

= Sum({<Year={"$(=FirstSortedValue(Year))"}>} Sale).

Besides is best to have computed expressions of set analysis to be within double quotes (").

Kiran.