Fiscal year syntax set expression

[#1]

Hi!

i have the following fields in my datamodel

fYear : Shown as Following 2014 (Represents 2013/2014 fiscal year)

FYear  : Shown as following 2013/2014

i would like my set analysis calculations to work with the FYear field as it is easier to select and understand for the user.

my current syntax works with the fYear however when  try with FYear i get 0 i think it has to do with /.

Current Syntax Below;

=sum({$<fYear=, fYear={$(=max(fYear))}>}Nettobelopp)

Best,

Brad

Message was edited by: Bradley Coyne

[tresesco]

Can you please share your sample app?

I guess that is not working because of the format, i.e. the max(FYear) result is not coming as in the FYear field, you need to take care of that.

[kumarnatarajan]

Hi,

I think it is format problem. so check your format.

try below syntax

=Sum({$<fYear={"$(=Year(Max(fYear)))"}>}Nettobelopp)

[#4]

hi i have attached the sample app

[tresesco · Accepted solution]

Use the below Expression:

=sum({$<FYear=, FYear={"$(=Dual(Max(fYear)-1 &'/'& Max(fYear), Max(fYear)))"}>}Nettobelopp)