Expression Logic

[sona_sa]

Hi Team,

I have list box: Name is Text and Option is 1M$, 2M$ and 3M$.

Now If User Select 1M$ then I need amount, which is greater than >1M$ from my records. Else By default, If Not selection is there – then 0, If user select 2M$ then greater than >2M$ from my records and when user select 3M$ then greater than >3M$ from my records and By default 0.

Below is my expression where I want to add this condition.

if(GetFieldSelections(Options1)='Millions',

if(GetFieldSelections(Options2)='No',

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

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

Can anyone make an expression for the same.

AK

[JordyWegman]

Hi Akumar,

In what are you going to make this? Can you show the objects that you are using?

Jordy

Climber

[sona_sa]

Hi Jordy,

I am not using any extension. Simple Straight Table. With one dimension and 3 Expression. Where once I select vSelection1 Period (Jan 2019) - 1st Expression display the data and when I select vSelection2 Period (Feb 2019) - 2nd Expression display the data. Third is difference -Expression1-Expression2. NOW another selection is there like.

I have Option1 Radio Button for Millions (M) and Full Value(##,###,##) and Option2 Radio Button for Yes or No Selection (Exclude IFRS Group options).

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 condition that is on Text Dimension --> 1M$ / 2M$ / 3M$ --> By default it is not selected, But If I select 1M$, From the straight table (Greatter Than) >1M$ Value should to display in straight table. If I select 2M$, From the straight table >2M$ Value should to display similarly for 3M$

For Threshold Options I have done the script -- 

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

Please check attached jpeg for any clarification.

Thanks for response. 

AK

[sona_sa]

Hi Jordy,

Itried by :

if(GetFieldSelections(roundingOptions)='Millions',
if(GetFieldSelections(ifrsOptions)='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