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

Slack Signup
Newsletter Optin
Help Desk

Calculating the annual projected use

Labels

This Discussion is public

Notifications

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:

Does anyone know how I can multiply this result by 365 to give a projected annual consumption?

Thanx

What is the formula that is giving this value of 0?

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.

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.