I’m having trouble with a key calculation in a table on a boolean value. I’m trying to replace the simple true/false word that comes into the simple table cell from the database query with just an “ON” for true and blank for false. I assumed the proper key calculation was something like:
@EndOfCycle== true ?"ON":""@
But nothing shows up in the cells that have the boolean as true for that cell. I tried comparing to 1, but then all the cells say “ON” regardless of the true/false status of the data from the database.
FYI, I pasted the query into the Database Query Browser, and that column is showing up as a checkbox, so I’m pretty sure it’s coming across as a true boolean datatype.
Looks like that’s working. The weird thing is, according to the docs I was reading, it shouldn’t work like that. Just the ? without a conditional should be testing for null/not-null.