Hi All,
Is it possible by expression, Below is required information:
I have a listbox : 1M, 2M and 3M, Created by Inline function, Below is script :
Option:
Load Inline [
Option, Num
'1 M $', 1000000
'2 M $', 2000000
'3 M $', 3000000
];
I have a straight table, Where All the possible value is displaying.
Now I want when I select 1M$, only greater than 1M value should to display in Straight Table.
When I select 2M$, only greater than 2M value should to display in Straight Table, Similarly to 3M.
How I can do the same: Below is my Expression.
If (GetFieldSelections(Option1)='Millions', if(GetFieldSelections(Option2)='No', Sum({<account={'EXPENSE'}>}Amount)/1000000, Sum({<sub_account={'EXPENSE_TYPE'}>}Amount_CC)/1000000),
if(GetFieldSelections(Option2)='No', Sum({<sub_account={'EXPENSE'}>}Amount), Sum({<sub_account={'EXPENSE'}>}Amount_CC))))
Can you feed the logic for the same.
Thanks,
AK
