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

Reply to this Discussion