Set analysis

[smilingjohn]

HI All,

Why is this expression not working ?

is there anything that i need to change ?

=sum({$<year=("$(=year(Today())))"}>}runs)

Thanks in Advance

[Anil_Babu_Samineni]

Yes you have to change it like below

=sum({$<year= {"year = Year(Today())"}>}runs)

[swuehl]

I think there is one closing ) too much:

=sum({$<year=("$(=year(Today()))"}>}runs)

[prma7799]

=sum({$<YEAR = {"($=Year(Today()))"}>}runs)

[smilingjohn]

Hi Anil,

This is not working

[Anil_Babu_Samineni]

As stefan notice one parenthesis looks like extra

[smilingjohn]

This is giving me the whole total ,

I want to display for the current year today the sum of runs

[smilingjohn]

HI stefan ,

THis is what i get the expression higlighted by the red lines ..and is nto giving the desired output

[prma7799]

instead of open braces (     put    curly braces    {

[Anil_Babu_Samineni]

Try this?

=sum({$<year=('$(=Year(Today()))'}>}runs)

or

=sum({$<year=('$(=Max(year))'}>} runs)

Note - I've seen reply to Stefan. Try above