Grid - sum and count [#1256626]

Hi,

I am working on patients questionnaires and I was wondering if there is an option to have the total of one grid and the number of answers in the report.
I have been using a calculation module for webform to do calculations #1251902: Webform calculated/computed values, however, it does not support the grid component.
Since our questionnaires have the same answer for many questions the grid is essential. Eventually, I need to find out the sum of all the questions in a grid (this is the patient's score) and also, how many questions had a numerical value, means answer not N/A.

Do you have an idea of what is the best way to do it?

Comments

Comment #1

jimbullington CreditAttribution: jimbullington commented 24 August 2011 at 18:25

At this time, the only option available in this module for this type of processing is the custom PHP code block. The module handles the webform data in a pretty vanilla fashion with only rudimentary formatting. There are a couple of examples of PHP code in the issue queue - I'll be glad to try and help you as time allows if you want to contact me directly.