In a form, I have a Net profit or loss field displayed in a TDO whose value is set in the Formula panel with this code:
?(«Nett receipts» > 0 and «Nett cost» > 0, pattern(«Nett receipts» - «Nett cost»,"$#,"), zeroblank(0))
I would like to have negative values (losses) displayed in red but I can’t see how to do it. I can always fall back on parentheses but red really jumps out at the viewer. is it possible?