I would like to do a simple formula like this:
IF Target<Actual THEN Target-Actual ELSE "Passed" END
But this means I need to mix integer and string, which doesn't work.
Any idea how to do it? May be with formatting?
I don't think this is possible. You can create only have same data type for both results.
Retrieving data ...