Sum calculation

[#1]

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.

[montubhardwaj · Accepted solution]

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