Skip to main content

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?

 

 

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


Ask your question here!

Terms & ConditionsCookie settings