Expression Help for Third Options.

[sona_sa]

Hi,

Thanks for reply. But here in the script:

Options1:
Load * Inline [
Options1
Millions
Full value];

Options2:
Load * Inline [
Options2
Yes
No];

Options3:
Load * Inline [
Options3
‘1M$’
‘2M$’
‘3M$’];

Expression :--> if(GetFieldSelections(Options1)='Millions',sum({<account={'EX'},Date={'$(=vTime1)'}>}a_expenses)/1000000, sum({<account={'EX'},Date={'$(=vTime1)'}>}a_expenses))),

if(GetFieldSelections(Options1)='Millions', if(GetFieldSelections(Options2)='No', sum({<account={'EX'},Date={'$(=vTime1)'}>}non_pti)/1000000, sum({<account={'EX'},Date={'$(=vTime1)'}>}non _pti_cc)/1000000)

Now I have to use options3 where user can select 1M$, so > 1M$ records should to select, If User Select 2M$ then >2M$ records should to select or if 3M$ then >3M$ records.

So Can anyone help me on this.

Lots of advance thanks.

Regards,

AK