Hi James,
Thank you for replying to my question. The coalesce() function is new to me and I think it can be helpful in the future. Nevertheless, I hoped that there would be an easier way to achieve the calculation results I am looking for. Right now and with regards to what you are writing may solution would be as follows:
-> For each edited field of the 32 fields - calculate, if it is the maximum and set the maximum question
-> For each edited field of the 32 fields - calculate, if it is the maximum and set the minimum question
-> Sum up all edited fields
-> Find out how many fields have been edited
-> Calculate the average value of all edited fields
Since I can only do one calculation per question I would need a lot of calculation questions to accomplish the task.
My hope was that I can kind of tag all fields that were edited. Then, the calculations would be:
-> max(all tagged fields)
-> min(all tagged fields)
-> sum(all tagged fileds) div count (all tagged fields)
Best regards,
Jürgen