Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have three list box in my sheet. Option1, Option2 and Option3. Below is Script:
Option1:
Load * Inline [
Option1
Million (Means will display the value in M)
Full Value (Means will display the value in Integer)
];
Option2:
Load * Inline [
Option2
Yes
No
];
Option3:
Load * Inline [
Option3
'1 M $'
'2 M $'
'3 M $'
];
Now I have to make an expression for calculation on -
If I select Option1 = 'Million ' and Option2 = 'Yes' and Option3 = '1M$' Then I want the sum of Non_PTI, Where Value will be in Million which is Greater Then 1M
If I select Option1 = 'Million ' and Option2 = 'Yes' and Option3 = '2M$' Then I want the sum of Non_PTI, Where Value will be in Million which is Greater Then 2M
If I select Option1 = 'Million ' and Option2 = 'Yes' and Option3 = '3M$' Then I want the sum of Non_PTI, Where Value will be in Million which is Greater Then 3M
For --> sum({<account={'EXPENSE'}>}non_ pti)
Else Full Value in Integer.
Can you make an expression for me.
Regards,
AK