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% ….
Why are non‑admin users unable to view Module information on the Anaplan page, while workspace administrators can? (After click the three dots on the grids right up corner) Are there any configuration options that allow non‑admin users to view module details without granting full workspace administrator access?
Just like the main question above, I wanted to try out the new feature on the board where you can you the insights panel to put additional cards. However, I wanted to synchronize scroll a card on the main board with the card on the insights panel but I can't find where it might be.
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
