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:

       

      CASE

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

      END

       

      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.