Survey Score

[Ralton Stewart]

is there anyway to add the survey score

[Dr Atul G- LNG · Accepted solution]

You need to change at table level, means, change the data type of string to Decimal. 

[Dr Atul G- LNG]

Hi @Ralton Stewart 

May be you need to change the type of report to get the average if survey score. could you please provide me table name so check at my end.

[Ralton Stewart]

Atul 

[Dr Atul G- LNG]

Hi @Ralton Stewart 

Sorry, I did not find this in my PDI. So tough for me to answer for this. I think if you chekc how the survey score is defined on CSM table and try that field in drop down and dot walk.

[Mark Manders]

Hi Ralton,

The reason it doesn't show, is that the score is set as a sting value, so calculations on that can't be done through a report. At one client we once solved this by creating a decimal field on the table and copied the value, making it also available in reports.