Including Text within a Number Formatted Line Item?

ashasli · April 20

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 · April 20

Hi @ashasli ,

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

SriNitya · April 20

@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 · April 20

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

SriNitya · April 22

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

Including Text within a Number Formatted Line Item?

Best Answer

Answers

Categories