Including Text within a Number Formatted Line Item?

ashasli

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

Arnab116

Hi @ashasli ,

You can use TEXT function to convert number to text format.

SriNitya

@ashasli
No is it not possible to include text within a number formatted line item but you can convert number to text and display then just for frontend UX showcase.

ashasli

@SriNitya thanks. How would you convert number to text in the frontend UX show case?

SriNitya

@ashasli
TEXT function to convert number to text format.
https://help.anaplan.com/convert-between-data-types-1a1ac604-62d2-4288-abaa-55fd8e2ee8e2