How to use current selection function for comparison of sales on basis of various seasons

[Anonymous]

Hi

i want to compare sales ie current year and previous year sales on basis of selection of season code from same  list boxes

so for current season i have declared variable as

vSales_summary_current_season=GetCurrentfeild([Season Code])

vSlaes_Summary_Current_Season=GetCurrentFeild(season code)-1)

expression for previous year season

Num( sum({$<Sold_year ={"$(=max(Sold_year)-1)"},season={$(vSales_Summary_Previous_Season)-1}>} [inv value]/Sales_INR_Unit ), '#,##0.0')

the above expression is giving an error

expression for current year

Num( sum({$<Sold_year ={"$(=max(Sold_year)-1)"},season={$(vSales_Summary_current_Season)}>} [inv value]/Sales_INR_Unit ), '#,##0.0')

[Anil_Babu_Samineni]

Just think algorithm of set analysis how and what it has? Then only we came to know. Anyway, To answer may be

Num( sum({$<Sold_year ={"$(=max(Sold_year))"},season={"$(=GetFieldSelections(GetCurrentField([Season Code])))"}>} [inv value]/Sales_INR_Unit ), '#,##0.0')

OR

Num(sum({$<Sold_year ={"$(=max(Sold_year))"},season={$(=Concat(Chr(39) & GetFieldSelections(GetCurrentField([Season Code])) & Chr(39), ',')}>} [inv value]/Sales_INR_Unit ), '#,##0.0')