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% β¦.
Can someone help me i am unable to login anaplan portal using my credentials
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to getβ¦
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made toβ¦
