I want to use a running total field to create a column in a chart but it looks like running total fields cannot be used in a chart via the Chart Expert.

 

Formula fields can be used to create a chart column. I've tried a number of different ways of using the COUNT function to return an integer but all attempts returned a syntax error. It would look something like this:

 

COUNT ({WHS_Survey.Has_survey_been_followed_up_on_}) = "Yes"

 

If you know of a way to use a running total field in a chart or how to fix my syntax I would be verrrry grateful.

 

Many thanks

Pete

Thanks!!