Hi All
Below is my Expression of Land Cost 1
if(match(Currency_P,'SG'),
money(
(
Ceil(
LAND_COST_TDS_SGD
,0.5)
)
,CurrencyFormat_P),
money(
(
Ceil(
FOB_SGD_SUB
,0.5)
)
,CurrencyFormat_P)
)
Below is my Expression of Land Cost 2
if(match(Currency_P,'SG'),
money(
(
Ceil(
LAND_COST_TDS_SGD
,0.5)
)
,CurrencyFormat_P),
money(
(
Ceil(
FOB_SGD_SUB*TAX_*DUTY_*TRANSPORT_SUB_*RATE_P/LESS
,0.5)
)
,CurrencyFormat_P)
)
Both are working fine . Now my task is to make 2 expression combine into 1 ( Land Cost 3 ) when user press TYPE = LOCAL PRODUCT.
My imagine expression look some thing like below :-
if(match(Currency_P,'SG'),
money(
(
Ceil(
LAND_COST_TDS_SGD
,0.5)
)
,CurrencyFormat_P),
)
if(match(TYPE,'LOCAL PRODUCT'),
money(
(
Ceil(
FOB_SGD_SUB
,0.5)
)
,CurrencyFormat_P),
)
money(
(
Ceil(
FOB_SGD_SUB*TAX_*DUTY_*TRANSPORT_SUB_*RATE_P/LESS
,0.5)
)
,CurrencyFormat_P)
But it display nothing.
