nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

UX related question!

aishabhy05

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?

Accepted answers

Dikshant

@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"

Dikshant

Try this formula:

If (Percent Line Item * 100) < 0 THEN "🔻" & TEXT(Percent Line Item * 100) & "%" ELSE "⬆️" & TEXT(Percent Line Item * 100) & "%"

All comments

Dikshant

@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"

MarkWarren

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…

aishabhy05

Thanks @MarkWarren and @Dikshant .

aishabhy05

Is it it possible to have % and the text line item together (with symbols)? output : 🔻-1 % … ⬆️ 5% @Dikshant @MarkWarren

Dikshant

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)

aishabhy05

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% ….

Dikshant

Try this formula:

If (Percent Line Item * 100) < 0 THEN "🔻" & TEXT(Percent Line Item * 100) & "%" ELSE "⬆️" & TEXT(Percent Line Item * 100) & "%"

Quick Links

Can you help?

Unanswered questions

Recommended Design for Determining Whether a Source Combination Exists in a Target List
Hello Anaplanners, I'm looking for advice on the best modeling approach for a DCA use case. Scenario I have an input module called "CC-Account Activation". It is dimensioned by: Cost Center (CC) Account Users can select an Activate? boolean to indicate that a Cost Center / Account combination should be activated. I have a…
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…