13 Replies Latest reply on Oct 12, 2018 1:13 PM by Deepak Rai

    Round a float number and then display it as str in a case statement

    Ale Fernández

      Hi everyone,


      I've seen other people answeing's about this issue, but not in a case statement. I have something like this:



      WHEN 'PRECIOSKU' THEN STR(ROUND(([PrecioSku1]),1))



      When I tried to put a Max or Min function after the Round Function, it appears without decimals. It would be easier if I use Left function, but It'd be wrong.


      I'd really appreciate your help.


      Thanks in advance.