Adding Two Statements Together! (HELP)

[#1]

HI GUYS, THIS IS BASICALLY ADDING 2 IF STATEMENTS TOGETHER, I'M NOT SURE HOW TO GO ABOUT DOING THIS, PLEASE HELP! THANKS!

I'VE ADDED THE QLIKVIEW FILE INSIDE AS WELL.

THANK YOU! =D

[erichshiino]

Hi,

I just replaced Duty and Tax by your if statements.

The result is:

if(match(Seg,'BP'),money(sum(Ceil(([Price(Euros)]*if([PRODUCT_TYPE]<>'TwinCAT', Tax,1)*if([PRODUCT_TYPE]<>'TwinCAT', Duty,1)*TRANSPORT*Rate)/BP,0.5)),CurrencyFormat),
money(sum(Ceil((PRICE*EURO*DISCOUNT_FACTOR*1)/SUB*if([PRODUCT_TYPE]<>'TwinCAT', Tax,1)*if([PRODUCT_TYPE]<>'TwinCAT', Duty,1)*TRANSPORT*Rate/Markup,0.5)),CurrencyFormat))

So,

Instead of Duty, you can use if( field='Value', 1, Duty)

in an expression:

1 * Duty * 150

became

1 * if( field='Value', 1, Duty) * 150

Rgds,