Greater Than 1M, 2M and 3M Value in Expression

[sona_sa]

Hi Team,

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'}>}cost_plus)/1000000, Sum({<sub_account={'EXPENSE_TYPE'}>}cost_plus_ex_cc)/1000000),
if(GetFieldSelections(Option2)='No', Sum({<sub_account={'EXPENSE'}>}cost_plus), Sum({<sub_account={'EXPENSE'}>}cost_plus_ex_cc-tp))))

Can any one help me on this.

Thanks,

AK

[sona_sa]

Can any one help me on this ?

Regards,

AK

[sona_sa]

Is there any solution for the same.

Regards,

AK

[rubenmarin]

Hi, I'm not sure of what you are trying, is the threshold for simgle value or for a sum of values?

Maybe something like this can work:

=sum({<Amount={">=$(=Max(Num))"}>} Amount)

[sona_sa]

Hi Rubemarin,

=sum({<Amount={">=$(=Max(Num))"}>} Amount)

I want on selection of 1M, value return only greater than 1M, similary for 2M and 3M.

and same expression - (=sum({<Amount={">=$(=Max(Num))"}>} Amount)) I want to feed in my below 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))))

Regards,

AK