Expression Help

[sona_sa]

Hi Team, I have a scenario like, Please check my attached screen shot.

I you will check, My selection --> VSelection1 --> I have selected Jan 2019 and VSelection2 --> I have selected Feb 2019 Below my Straight Table where Variance1 --> is VSelection1 selection data and  Variance2 --> is VSelection2 selection data and Variance --> is Column1- Column2 (Output).

On the left side Millions and No (Exclude IFRS Group) Is selected.

For this screen shot--> These are the parameter I have used and my expression logic is working properly. Expression is below:

if(GetFieldSelections(roundingOptions)='Millions',

if(GetFieldSelections(ifrsOptions)='No',

sum({<account={'EXPENSE'},NewDate={'$(=vSelection1)'}>}non_ pti)/1000000,

sum({<account={'EXPENSE'},NewDate={'$(=vSelection1)'}>}non_ pti_ cc)/1000000)

Now I want one more selection that is on leftside - Threshold --> 1M$ / 2M$ / 3M$ --> By default it is not selected, But I selection 1M$, From the straight table >1M$ Value should to display in straight table. If I select 2M$, From the straight table >2M$ Value should to display.

For current screen shot only 2 row will be display --> i.e Gross Revenue and Controllable.

For Threshold I have done the script -- 

Threshold:
Load * Inline [
Text, Value
'1 M $', 1000000
'2 M $', 2000000
'3 M $', 3000000
];

So team can you help me on this.

Regards,

AK

[Anil_Babu_Samineni]

If those variables are from Input box, Difficult to know what you are trying. But, If you are trying with Filter box you can try this way

if(GetFieldSelections(roundingOptions)='Millions',

if(GetFieldSelections(ifrsOptions)='No',

sum({<account={'EXPENSE'},NewDate={'$(=Concat(Distinct Chr(39) & vSelection1 & Chr(39)))'}>}non_ pti)/1000000,

sum({<account={'EXPENSE'},NewDate={'$(=Concat(Distinct Chr(39) & vSelection1 & Chr(39)))'}>}non_ pti_ cc)/1000000)

[sona_sa]

Hi Anil,

Thanks for reply, But in my current selection Brother, Everthing is working. VSelection1 and VSelection2, Million radio buttun, IFRS options.

Now I want one more selection that is on leftside - Threshold --> 1M$ / 2M$ / 3M$ --> By default it is not selected,

But If I select 1M$ from Threshold, From the straight table >1M$ Value should to display in straight table. If I select 2M$, From the straight table >2M$ Value should to display.

For current screen shot only 2 row will be display for 1M$ selection--> i.e Gross Revenue and Controllable.

For Threshold I have done the script -- 

Threshold:
Load * Inline [
Text, Value
'1 M $', 1000000
'2 M $', 2000000
'3 M $', 3000000
]; 

Hope you got my point. I want to add the third condition for threshold thing in my expression. Million and No Selection is working. 

Regards,

AK

[sona_sa]

Hi Anil,

Any Suggestions for the same.

Regards,

AK

[sona_sa]

Hi,

I tried by :

if(GetFieldSelections(Options1)='Millions',
if(GetFieldSelections(Options2)='No',

sum({<sub_account={'EXPENSE_TYPE'},NewDate={'$(=vTime1)'},Text,Value={">$(=only(Value))"}>}non_controllable_pti)/1000000,
sum({<sub_account={'EXPENSE_TYPE'},NewDate={'$(=vTime1)'},Text,Value={">$(=only(Value))"}>}non_controllable_pti_ex_cc)/1000000)

Not Working.

AK