Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a field 'RIDReportable' which stems from a tick box and holds either 1 (ticked) or -1 (unticked).
What is the correct syntax in the script to translate this so from 35 responses, I can see Yes or No instead of 1 or -1 in the straight table?
Its currently
1 - 1
-1 - 34
And I wish to show
Yes - 1
No - 34
Any ideas?
Hi
The syntax is: If(PIDReportable =1, 'Yes', 'No')
Hope that helps
Jonathan
Hi
The syntax is: If(PIDReportable =1, 'Yes', 'No')
Hope that helps
Jonathan
Many thanks Jonathan