Using GetFieldSelections in an expression

[#1]

Hi,

Hopefully a quick question.

I have a master calendar and an assoicated table full of sales values.  What I want is two columns in a straight table, the first showing the values from the selected year from a listbox populated from the master calendar.  The second column needs to show the values from the previous year.

I have left the first column's expression as =Sum([DAILYSALES-SALES-VALUE-EXTAX])

The second column's expression as =Sum({$<CALENDARYEAR=GetFieldSelections(CALENDARYEAR)-1> [DAILYSALES-SALES-VALUE-EXTAX])

The editor says there is a syntax error, but I dont't know how to fix it.

Can someone point me in the right direction with regards to using GetFieldSelections within an expression, or alternatively is there another/better way to get year on year comparison within a straight table, where the user either selects a single year from a list box, or has to select two years?

Thanks

Trevor

[CELAMBARASAN]

Hi,

     Use Expression as

     =Sum({$<CALENDARYEAR={$(=Max(CALENDARYEAR)-1)}> [DAILYSALES-SALES-VALUE-EXTAX])

Celambarasan

[lironbaram]

you need to change to

Sum({$<CALENDARYEAR={"$(=GetFieldSelections(CALENDARYEAR)-1)"}> [DAILYSALES-SALES-VALUE-EXTAX])

[#4]

Hi Syntax now shows as ok, but I don't get any data returned at all

[#5]

Hi, as per other post, syntax shows ok, but still no data being returned.  The syntax looks very strange to me?  What is the purpose of all the double quotes ?  I can't find anything about this in the reference guide.

[CELAMBARASAN]

Hi,

     Check with this expression

     =Sum({$<CALENDARYEAR={'$(=Max(CALENDARYEAR)-1)'}> [DAILYSALES-SALES-VALUE-EXTAX])

Celambarasan

[jagan]

Hi,

Try this expression

   =Sum({$<CALENDARYEAR={'=$(=Max(CALENDARYEAR)-1)'}> [DAILYSALES-SALES-VALUE-EXTAX])

Hope this helps you.

Regards,

Jagan.