Set analysis Year range

[#1]

Hi guys,

Can somebody show me on how to write the following condition in set analysis properly?

If(FiscalYear>=2014 and FiscalYear=Year(Today()))

I tried something like this but doesn't seems to yield the result I expected

{$<FiscalYear={">=2014"}, FiscalYear={"=$(=Year(Today()))"}>}

Thank you for your kind attention guys

Regards,

Khairul Anuar Azuddin

[#2]

hi,

Plz explain,if u want this..

if fiscal year is greater than equals to 2014,then u need to show todays date of year

or as u wrote and in between ..then if the conditions fulfills then what do u want to show.

thanks

sudhanshu shrivas

[#3]

Hi Sudhanshu Shrivas,

This is what I intended

Sum({$<FiscalYear={">=2014"}, FiscalYear={"=$(=Year(Today()))"}>} Amount)

FiscalYear	Amount
2013	100
2014	200
2015	30

Basically I want to ignore anything prior to 2014, which means say today is the 2014, the amount up would be 200. Hypothetically if today is 2015 it would be 30.

If I write the set analysis like this,

Sum({$<FiscalYear={"=$(=Year(Today()))"}>} Amount)

The set analysis would defy the original condition that I intended in which it would also show the amount prior to 2014.

Thank you for your kind attention.

Regards,

Khairul Anuar Azuddin

[consenit]

Hello.

There seems to be an extra equal sign. Try this:

=Sum( { $< FiscalYear={">=2014"},  FiscalYear={"$(=Year(Today()))"} > }   Amount)

[engishfaque]

Dear Khairul,

Here is the set analysis,

Sum({$<FicalYear = {'>=2014'}>} Amount)

Kind regards,

Ishfaque Ahmed

[Anonymous]

Hi Khairul,

Try below:

=Sum( { $< FiscalYear={">=2014"},  FiscalYear={"$(=Year(Today()))"} > }   Amount)

or

=Sum( { $< FiscalYear={">=$(=Year(Today()))"} > }   Amount)

Regards

Neetha

[gandalfgray]

Hi Khairul

Your original condition does not match what you write in your first comment.

You started with the pseudo code

If(FiscalYear>=2014 and FiscalYear=Year(Today()))

(which means  FiscalYear 2014 or after (that is 2014,2015,2016 etc) and FiscalYear of today (that is 2014, and in a few weeks 2015)

then you write "the original condition that I intended in which it would also show the amount prior to 2014" - if this is what you want the statement should be written

If(FiscalYear<2014 and FiscalYear=Year(Today()))

anyway

if you want a set statement for the first case it would be:

{<FiscalYear={">=2014","$(=Year(Today()))"}>}

and if you want it for the second case (include prior to 2014) it will be:

{<FiscalYear={"<2014","$(=Year(Today()))"}>}

hope this helps

/gg