PQL Dynamic text formatting
I'm trying to write a PQL for dynamic text, so that when the data value selected in my matrix is equal to or greater than 0 it's formatted as Green.
I've written the below but it's not working, how would i write this PQL correctly?
Try this one:
if(data(0,1) >= 0, fontformat(formatteddata(0,1), "Green"), fontformat(formatteddata(0,1), "Red"))
I'm not sure why that first format was there. Also the formattedData function will return the value as displayed in the grid instead of the raw value which might not be nicely formatted.