5 Replies Latest reply on Jan 15, 2019 12:17 PM by Ken Flerlage

    Select a Metric - Dynamic Number Format

    Stephan Jones

      I'm building something out that uses a parameter for the user to select various metrics that unfortunately all have various number formats. I've included a sample workbook with 3 different examples (not inclusive of all metrics, but examples of the 3 types of formats)

       

      AHT - no decimal places

      NPS - 1 decimal place

      Survey Resut - 1 decimal place as a percentage

       

      I've attached an extract to see an example of how the data will be calculated.

       

      Any help is appreciated.