Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hello.
There seems to be an extra equal sign. Try this:
=Sum( { $< FiscalYear={">=2014"}, FiscalYear={"$(=Year(Today()))"} > } Amount)
Dear Khairul,
Here is the set analysis,
Sum({$<FicalYear = {'>=2014'}>} Amount)
Kind regards,
Ishfaque Ahmed
Hi Khairul,
Try below:
=Sum( { $< FiscalYear={">=2014"}, FiscalYear={"$(=Year(Today()))"} > } Amount)
or
=Sum( { $< FiscalYear={">=$(=Year(Today()))"} > } Amount)
Regards
Neetha
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