Hi everyone, I have a saved search with a Forumla ...
# administrationa
andrewm
02/10/2021, 4:28 PMHi everyone, I have a saved search with a Forumla (Text) field with th evalue below. The pricelevel is 2.50 but on the Results this shows 2.5 - I lose the second decimal. This doesnt seem to happen if the price is 2.99 - any ideas? thanks
Copy code
case when {salestaxcode}='S-GB' then ROUND(({onlineprice}*1.2),2) else {onlineprice} end || ' GBP'p
PNJ
02/10/2021, 4:42 PMcase when {salestaxcode}='S-GB' then TO_CHAR(ROUND(({onlineprice}*1.2),2),'999999999.99') else {onlineprice} end || ' GBP'PNJ
02/10/2021, 4:42 PMTry that
a
andrewm
02/11/2021, 9:28 AM@PNJ Thanks, but I get Invalid Expression
andrewm
02/11/2021, 10:05 AMTO_CHAR(ROUND(({onlineprice}*1.2),2),'999999999.99') that worked, so must be formula issue...
3 Views