The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group
Calculating the annual projected use
I am trying to find a way to calculate the annual projected use of Chlorine based on the average daily consumption. I have the following which calculates the daily average consumption over the past period we have been monitoring it:
0
Does anyone know how I can multiply this result by 365 to give a projected annual consumption?
Thanx
May 2, 2017 at 8:18 pm
What is the formula that is giving this value of 0?
May 3, 2017 at 11:08 am
Odd that the formula did not show in my post... It this one: [frm-stats id=211 type=average]
However we have found this formula does not work either as it gives the average of only the forms submitted as opposed to the average over the number of days.
May 3, 2017 at 2:11 pm
I think you will need to work with the stats filter feature as per https://formidableforms.com/knowledgebase/add-field-totals-and-statistics/#kb-field-filters
Discussion closed.