Is it possible to have the arrow marks as shown in the screenshot below? Like, it should not be a fixed one, it should be dynamic. If yes how this is achievable?
@aishabhy05, Write the formula for the text format line item with emojis, using IF and ELSE statements for different emojis.
IF Salary < 50000 THEN "🔻" & "Low Salary" ELSE "⬆️" & " High Salary"
Try this formula:
If (Percent Line Item * 100) < 0 THEN "🔻" & TEXT(Percent Line Item * 100) & "%" ELSE "⬆️" & TEXT(Percent Line Item * 100) & "%"
To improve on this, create a list for each Salary Band and put the text there; then use a list formatted line item for display, not text. Also, there's no need to be doing the text concatenation here…
Thanks @MarkWarren and @Dikshant .
Is it it possible to have % and the text line item together (with symbols)? output : 🔻-1 % … ⬆️ 5% @Dikshant @MarkWarren
You have to convert the number format line item into text using TEXT function and then do the concatenation
Example:
If Percent Line Item < 0 THEN "🔻" & TEXT(Percent Line Item) ELSE "⬆️" & TEXT(Percent Line Item)
Thanks @Dikshant I already tried, however I'm not getting % it is showing me something like this .. I want the exact % to be captured.. like ⬈ 0.1% ….
Hi, I'm trying to trigger a workflow template from UX as an end user and it fails See below The context: I've got my hands on Anaplan Workflow and testing some stuffs and it's suitability on our existing business processes. We already have a Price approval process configured as a custom workflow driven by booleans and…
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
