IF Statement on to be done on a Selected Field

[Anonymous]

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

[Anonymous]

Here is the updated file -sorry about that

[balabhaskarqlik]

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)

[balabhaskarqlik]

=If(Currency ='Local', Count({<SIMULATE.Sim_Year = {'$(=GetFieldSelections(Calendrier.Année))'>}SIMULATE.Sim_Rate),1)

[balabhaskarqlik]

=If(Currency ='Local', AVG({<SIMULATE.Sim_Year = {'$(=GetFieldSelections(Calendrier.Année))'>}SIMULATE.Sim_Rate),1)