Question

Emojis in dimension to define status

  • 10 August 2023
  • 1 reply
  • 67 views

Userlevel 2
Badge +2

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

Userlevel 6
Badge +12

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.

 

Reply