Logic Help

[sona_sa]

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
'1 M $'
'2 M $'
'3 M $'
];

Now I have to make an expression for calculation on - 

If I select Option1 = 'Million ' and Option2 = '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 = '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 = '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. like --> 20000000000.25614

Can anyone make an expression with these 2 condition  for me.

Regards,

AK

[Vegar]

Its hard to really understand what you want. 

Your last post disregards all my earlier suggestions and adds a new data set in which do not have all the fields referenced in your expressions. 

It would be better if you tried to update the qvf and post it with a more pin pointed question. 

-Vegar

[sona_sa]

Hi Vegar,

I can understand. Everything is same. Only I have added the actual data for the same. Now I want as it is whatever you have done in updated version of qvf. Earlier you was generating the data by using of RAND function. Now I have provided you the original data. i.e below:

Sub_Account	Cost_Plus	Cost_Plus_CC	transfer_price	transfer_price_excc	Year
Expense	30000000	578300000	179506000.9	273592000	2019
Expense	31000000	624100000	179507000	274559000.3	2019
Expense	34100000	782400000.9	199181000	280056000.7	2019
Expense	34500000	796700000.1	204975000.3	302410000.4	2019
Expense	34800000.98	928000000	206196000.7	302797000.4	2019
Expense	54300000	947600000	231799000	325057000.5	2018
Expense	54700000.21	1023800000	237569000.7	325777000.1	2018
Expense	57000000	1027500001	250111000.5	372404000.4	2018
Expense	60800000	1063600000	272898000.2	388108000.4	2018

All selection whatever you have done perfect.

Sum( cost_plus, cost_plus_ex_cc, transfer_price and transfer_price_ex_cc) all these field calculation. Output is below.

Year	2018	2019
Cost Plus	69.9	68.3
Transfer Price	191.1	146.7

All selection is perfect. Only this output required.

Lot of thanks, for co-operation.

Regards,

AK