Expression Logic

[sona_sa]

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