Fiscal Year Comparison

[#1]

Hi

i have a field in my table with the name BE_Fiscal_Year and some amount associated with every Fiscal  Year,

I want to sum all the amount for the current fiscal year ( i have calculated current fiscal year in a variable by the formula YearName(Today(),0,7) , and it has correct value in it),

I want to write a simple expression which sum the values of all the amounts for the value in the variable

sum({<BE_Fiscal_Year={"$(Current_Fiscal_Year)"}>}  amount)

Thanks & Regards

[#2]

Hi,

Try This One

sum({<BE_Fiscal_Year=, BE_Fiscal_Year={"$(Current_Fiscal_Year)"}>}  amount)

[#3]

Hi,

try this

=sum( { <[BE_Fiscal_Year]={$(Current_Fiscal_Year)} >} amount)

remember that BE-Fiscal_Year shoud be in number format not text.

regards

Apurva

[jagan]

Hi,

Try this

=sum({<BE_Fiscal_Year={'$(=Current_Fiscal_Year)'}>}  amount)

Check wheter BE_Fiscal_Year and Current_Fiscal_Year format are same.

Regards,

Jagan.

[#5]

thank you everyone, i got the solution

sum({<BE_Fiscal_Year={"=$(Current_Fiscal_Year)"}>}  amount)