2 Replies Latest reply: Dec 22, 2011 9:01 AM by Sunil Chauhan RSS

    Grand total count of several Chart Expressions

      Hi all,

       

      I have a question about creating a Grand Total count in an Chart Expression, based on the data in other Expressions.

      In my Chart, I have 7 Expressions (Deviat...), counting False values from my data. I want to create one Expression counting the total sum of all False-values from the other 7 Expressions (GrandTotalDeviations). Is this possible to do?

       

      22-12-2011 14-13-59.jpg

      The syntax I've used in my 7 Expressions are pretty much the same, and in ex. DeviateWidthCU it's like:

       

      IF(ViewKontrollMaling.Pakningsniva like 'CU',
      IF(SUM(ViewKontrollMaling.KontrollMaltBredde+Toleransegrenser.MalTorr+0.0001) 
       > SUM(ViewKontrollMaling.OpprinneligBredde), 0, 1)
       OR
      IF(SUM(ViewKontrollMaling.KontrollMaltBredde-Toleransegrenser.MalTorr-0.0001) 
       < SUM(ViewKontrollMaling.OpprinneligBredde), 0, 1))