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
