7 Replies Latest reply: Sep 23, 2016 9:10 AM by Neil Deeley RSS

    Measure not dividing by variable amount

    Neil Deeley

      Hi there,

       

      I'm trying to calculate percentage values in a table.

       

      I've created a variable called (AC - DWS) which calculates the total number of records for a measure. This calculates and I can output the results to a text box:

       

      p1.jpg

      I'm using this variable to divide by the total records for a particular dimension., If I manually add the result as a number, the division works:

       

      P2.jpg

       

      If I use the result of the variable, it doesn't:

       

      P3.jpg

       

      Any idea why? It also doesn't work if I add the calculation used to get the variable value:

       

      Count({1<[Ops Function]={'Drinking Water'}, DataSource={'Alarms'}, [Alarm Status]={3}, Date={'>=$(=Date($(vTodaysDate)))'}>} AlarmCount)

       

      Any help gratefully received!