Peter Bertelsen
11/15/2019, 9:34 AMJohan Torres
11/15/2019, 4:07 PMRicardo
11/15/2019, 4:45 PMBrian Keare
11/15/2019, 6:20 PMSimon
11/15/2019, 6:50 PMSimon
11/15/2019, 6:51 PMSimon
11/15/2019, 6:52 PMsandra
11/15/2019, 8:18 PMTwoStep
11/15/2019, 8:37 PMTwoStep
11/15/2019, 8:39 PMKevinJ of Kansas
11/15/2019, 8:44 PMGarrett
11/15/2019, 9:08 PMSara L
11/15/2019, 9:21 PMSara L
11/15/2019, 9:37 PMirurzo
11/16/2019, 6:59 PMmattb
11/17/2019, 11:29 PMLTRIM({pricing.pricelevel},'Base -')
to also trim the word “Promo -“?michoel
11/17/2019, 11:31 PMLTRIM(LTRIM({pricing.pricelevel},'Base -'), 'Promo -')
michoel
11/17/2019, 11:36 PMREPLACE
instead of LTRIM
mattb
11/17/2019, 11:48 PMmattb
11/17/2019, 11:50 PMmattb
11/18/2019, 12:04 AM'NA'
to a different numeric based field like {pricing.unitprice}
then it’s finemichoel
11/18/2019, 12:04 AMTO_CHAR
michoel
11/18/2019, 12:04 AMCASE WHEN {custitem_consumer_unit_rrp} IS NULL then 'NA' ELSE TO_CHAR({custitem_consumer_unit_rrp}) END
michoel
11/18/2019, 12:07 AMTO_CHAR({custitem_consumer_unit_rrp}, '9,999,999.99' )
mattb
11/18/2019, 12:09 AMmattb
11/18/2019, 1:51 AMCASE WHEN {custitem_carton_uom} = '1' THEN 'oneunitonly' ELSE (CASE WHEN {taxcode} = 'TS-AU' THEN ({pricing.unitprice}/{custitem_carton_uom})*1.1 ELSE 'notax' END) END
just working through this one so that if {custitem_carton_uom}
= 1 then print text, otherwise follow the formula afterwards but only if {taxcode}
= TS-AUmichoel
11/18/2019, 1:58 AMmichoel
11/18/2019, 1:58 AMCASE
WHEN {custitem_carton_uom} = '1' THEN
'oneunitonly'
WHEN {taxcode} = 'TS-AU' THEN
({pricing.unitprice} / {custitem_carton_uom}) * 1.1
ELSE
'notax'
END
michoel
11/18/2019, 2:00 AMcustitem_carton_uom
numeric or text? If numeric then maybe change {custitem_carton_uom} = '1'
to {custitem_carton_uom} = 1
, if text the division later might cause a problemmattb
11/18/2019, 2:01 AM