Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
Hi Anil,
Any Suggestions for the same.
Regards,
AK
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