6 Replies Latest reply on Oct 17, 2016 10:38 PM by Shinichiro Murakami

    Different number formatting and calculations in the same column

    Gabriel de Leon

      Hi Guys,

       

      I've got a couple of issues I'm trying to address, hoping that you can help out.

       

      So the first one is showing numbers in different formats when they are originating from the same column in the data source. So some a percentages, others are whole numbers, and others are dollars. Is there any way to have them all showing at the same time with the relevant number format?

       

      The second issue I'm facing, because they need to different formats, when comparing them against a target column, the target calculations are different as well. So for the percentages they need to be averaged, for the whole numbers and dollars they need to be summed. Is there anyway around this?

       

      Example work book attached.

      Thanks in advance for any help you can provide.