Hey All,
I am stuck trying to change a ROLLUP % field into a string so that it can be displayed in an automated GoogleDoc. At the moment when I try to create a string it fails to display anything in GoogleDoc tests, just shows a blank space. In the automation plain I can select the field without a problem.
The ROLLUP % I am trying to turn into a string is a summary of one of the criteria in our survey → the roll up field is called “CourseDesign%”
IF(values, (AVERAGE(values) / 5))
My attempt at creating a string is:
IF(LEN(CONCATENATE({CourseDesign%}))>0,CONCATENATE((ROUND({CourseDesign%}*100))&“%”))
Any assistance appreciated! Thanks