1 Reply Latest reply: Aug 25, 2010 6:58 AM by Dinesh Kumar RSS

    Sum calculation

      Hi

      1. I currently have a bar chart which drills down into my various options. I am looking to display only Operations_scrapped. My chart is set up when I go to the properties, expression tab, in the definition box I was the following statement:

      NumericCount (Scrapped_Operations). This does not work as it shows me all the operations and not just the scrapped ones. Can someone help me with the expression I need to use.

      Thanks.

        • Sum calculation
          Dinesh Kumar

          Hi Kelley,

          In the expression, you can try filtering the results only for "Scraped" ones.You can use IF,ELSE condition something like this.

          = Count(IF(<Your Field> ='Scraped',<Your Field>))

          Hope this was helpful.

          Regards,

          Dinesh Sharma