11 Replies Latest reply on Jan 24, 2017 12:16 AM by Norbert Maijoor

    How can create Calculation for Min & Max or Good & Bad for a dimension analyzed at a row base?

    Khalid Baker

      Hey Everyone;

       

      Suppose I have a dimension called KPI and within in it I have 5 KPIs for a Category (another dimension). Each KPI has a different criteria, which means for some the higher the value the better, whilst others the lower the better. How can we create a formula portraying that logic?

       

      Thanks;

      Khalid