topic Set Analysis - Dual field numeric comparison in App Development

Set Analysis - Dual field numeric comparison

shanemichelon — Sat, 16 Nov 2024 21:33:48 GMT

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?

Re: Set Analysis - Dual field numeric comparison

zzyjordan — Tue, 22 Jan 2019 01:10:00 GMT

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

ZZ

Re: Set Analysis - Dual field numeric comparison

shanemichelon — Tue, 22 Jan 2019 01:21:07 GMT

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.