18 Replies Latest reply: Aug 30, 2011 7:02 AM by Annika Palm RSS

    to many decimals that can't be removed?

    Annika Palm

      Hi,

       

      I'm strugguling with a decimal-problem. In my source data i have numbers with 2 decimals (source data is an xml-file and i have checked it a 100 times, only 2 decimals). ok.

       

      In my senario i store one of these numbers as a variable and then in one of my chart i want to color cells according to weather or not the number is higer, lower or equals that variable number. Piece of cake i thougt. But. if i subtract my set analysis statment (which contains numbers from the same field the variable is from) from the variable i end up with a differ.

       

      I've attaced my chart (straight table) so that you can see the expresssion.

       

      I've tried everything so that's why i need you guys.

       

      Thanks!

       

      table.JPG