4 Replies Latest reply on Jul 23, 2018 4:02 PM by Hari Ankem

    Only showing decimal places with value.

    Drew Lincoln

      I am currently struggling with a little formatting problem that I hope you all can help me with.

       

      In calculating the averages of sales based off weekdays I have it rounding to 2 decimal places, which is what I want. However, my whole numbers that have no decimal values I just want to stay a whole number. For instance right now my values that come back would be 1.67 and 2.00.

       

      I want it to be represented as 1.67 and 2 with no trailing decimal or zeroes as I feel it just makes it look a little bit cleaner.

       

      Any suggestions on how I could accomplish this?

       

      Thanks!