1 Reply Latest reply: Apr 1, 2015 10:33 AM by Friedrich Hofmann RSS

    Formatting problem - numeric or not?

    Friedrich Hofmann


      Hi,

       

      I have the following problem:

      - From one file, I get a ready-made figure (which is cost_per_minute), that is numeric and has 4 decimals.

      - From another file, I have - actually the same figure, cost_per_minute.

      <=> My problem is, that second figure has 8 decimals and I want only 4 - I need to re-do a calculation like our customer

             has done it with 4 decimals, so I need to avoid rounding errors.

      <=> For some reason, I can't seem to be able to format that with just 4 decimals.

       

      I can attach the Excel_file that I use to get the second figure (it's the last line; It has 8 decimals like I said, though it's now formatted with 4; I need just 4); The first one, which has just 4 decimals, is below in the same file.

       

      => I want to concatenate both those figures in one table.

      Can anyone help me do that?

      Thanks a lot!

      Best regards,

       

      DataNibbler