Adjusting the results of a loaded field

[#1]

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?

[jonathandienst · Accepted solution]

Hi

The syntax is:   If(PIDReportable =1, 'Yes', 'No')

Hope that helps

Jonathan

[#3]

Many thanks Jonathan