Sum Function - Report

I am reiterating a question posed in June 2019, which went unanswered. I have a question in one of my surveys asking about the total expenses incurred from an activity. I would like to create a Custom Report that will show all the expenses from each submission, and also add those expenses into a total. I have attached a photo of what my report currently looks like.

Hi @rebeccah66,

Welcome to the community! Would you mind providing us a sample questions maybe 2 to 3 so that we could show you how it’s possible to build a custom report based on the available variables that we have.

Have a great day!

Hi,
On our article that details use of advanced calculations (link), we explain various computation approaches.

To answer your specific question

We need to break this into two

This is definitely possible since you can create a summation of all the expenses using simple formulas like ${Q1}+${Q2}+${Q3} OR SUM(${Q1},${Q2},${Q3})

As for the second part

If you had ideally created a sum for each submission, you should be able to do this off the report where you get the totals for them. There is no way to make a computation between submission instances. The report will only show you the default measures if you had made the calculation on an integer type of question

Stephane

Hello @stephanealoo ,
do I understand well? The sum in the report would only be possible, if it was already included in the filled (and submitted) form version used before.
As far, as I can see, a filled form cannot be extended later by any new calculate or other variables, as the filled form is linked to a fixed (empty) form version.

  • Is this right? And is there any workaround to do this?

Hi

Yes this is true

You are right

None that I am aware of

Stephane

1 Like