expression

[raadwiptec]

my earlier requirement has changed to following need another new expression on the front end..

I have the following 3 columns

1. Billing Type

2. Quantity

3. Location

Billing Types are '6001','6002','6003','6554','5101','5102','5251','5352','7401','7302','4951','3952','2961','9362',2001','2002'

Based on the Billing Types quantity should be derived as below

-6001+2001+2002-6002-6003-6554-5101-5102-5251-5352-7401-7302-4951-3952-2961-9362

Note: - Consider the quantities of 2001 and 2002 only If the Location is Null

Foe example the above shows if the billing type is 6001 then it should be quantiy *-1

Suggest here

[sunny_talwar]

I don't think I understand the logic you are using here, can you provide a sample data in an Excel file for all three columns and then tell the expected output?

[raadwiptec]

hi sunny

attached excel/