Set Analysis - Dual field numeric comparison

[shanemichelon]

I have a question about using set analysis with DUAL field.  Say I have a field called FY (Financial Year).  Lets say it is a dual with values like:  Text(FY) = '2018/2019', Num(FY)=25

Ie an autonum representing the numeric version and text for the human version.

Lets say I want to get a specific year:

Sum({$  <FY={15} > }  Amount)

This does not work.  I think it is because it is a Dual field.  Thoughts?

[zzyjordan · Accepted solution]

Hi,
Try this
Sum({<FY={">=15<=15"}>} Amount)

ZZ

[shanemichelon]

Thanks. Yes I considered that and I think it will work, but for the purposes of example, I simplified the actual case. In actuality it would be is something more like:
Sum( {$ <FY={">=$(=Max(FY)-1)<=$(=Max(FY)-1)}>} Amount)

I guess that's ok, but it seems like a work around.