4 Replies Latest reply: Mar 6, 2014 4:49 AM by Sara Titmuss RSS

    Creating % analytics

    Sara Titmuss

      Hello,

       

      I have a chart to which I am trying to show a % of products used.  However, I've hit a dead end asto how to create this.  I currently have the following expression which gives me the total value of the product used:

       

      =num(sum(OKM_POTENTIALVALUE)

       

      I want to then divide this into the total for a specific procedure which the expression is the same.  Any ideas on how I can do this?

      (The tab in question is the Consumable tab)

       

      (Hope it makes sense)