Skip to main content
Question

Emojis in dimension to define status

  • Aug 10, 2023 9:24 PM UTC
  • 1 reply
  • 394 views
Guillermo Puls
Wallflower
Forum|alt.badge.img+1

Hi community,

 

I have a numerical metric delivering a variance between Actual and Budget.

I’m trying to create a metric (text), that transform a negative variance into a text (enabling me to add emojis there)

My problem is that when I try the formula times out. What could lead to a formula time out?

 

 

    1 reply

    Benoit
    Community Manager
    Forum|alt.badge.img+17
    • BenoitCommunity Manager
    • Community Manager
    • Aug 14, 2023 12:58 PM UTC

    Hi Guillermo,

     

    We can notice that your metric is structured by 7 dimensions which most probably exceeds what we can handle as your formula returns a result on all cells.

    Maybe you can try to reduce the scope of your formula to say:

    IF( isdefined(metric), IF(metric >=0, “ok”, “not ok” ) )

    or

    IF( isdefined(metric) and metric >=0, “ok”, “not ok” )

    Please let us know if it helps.

    Thanks.

     

    Benoit - Pigment wizard

      Ask your question here!

      Terms & ConditionsAccessibility statement