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

Accepted answers

ArnabG

Hi @ashasli ,

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

All comments

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?

ArnabG

Hi @ashasli ,

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

SriNitya

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

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…