Including Text within a Number Formatted Line Item?


Our client requests to see "no MTA" when MTA= 0 and Warehouse <> 0.

However, instead of 'no MTA', I'm getting 'NaN'. Is it possible to include text within a number formatted line item?

Formula - Final MTA = IF MTA = 0 AND Warehouse <> 0 THEN VALUE("No MTA") ELSE MTA

Best Answer