Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a requirement to select a year which comes from the front-end and then execute an IF Statement in a chart.
For example when 2018 is selected go and get a particular value or else select 1.
I cannot for the life of me get this working.
This is my year selection: SIMULATE.Sim_Year = GetFieldSelections(Calendrier.Année)
This is my IF Statement: if(Currency ='Local',SIMULATE.Sim_Rate,1)
I need to get the year of the Sim_Rate or the Year of 1.
I've tried various combinations and I cannot seem to get this to work.
SIMULATE.Sim_Year = '($(=GetFieldSelections(Calendrier.Année))', if( Currency ='Local', SIMULATE.Sim_Rate,1)
Any help would be greatly appreciated.
Paul
Here is the updated file -sorry about that
Try like this:
=If(Currency ='Local', Sum({<SIMULATE.Sim_Year = {'$(=GetFieldSelections(Calendrier.Année))'>}SIMULATE.Sim_Rate),
1)
OR
=If(Currency ='Local', Sum({<SIMULATE.Sim_Year = {"$(=GetFieldSelections(Calendrier.Année))">}SIMULATE.Sim_Rate),
1)
=If(Currency ='Local', Count({<SIMULATE.Sim_Year = {'$(=GetFieldSelections(Calendrier.Année))'>}SIMULATE.Sim_Rate),1)
=If(Currency ='Local', AVG({<SIMULATE.Sim_Year = {'$(=GetFieldSelections(Calendrier.Année))'>}SIMULATE.Sim_Rate),1)