Skip to main content

Hi there!

I've a problem using a variable in a formula of OLAP_TABLE.

I've two variables (Interv_1, prueba_var1) text/replacement Type, with values:

Interv_1=OTHER

Prueba_var1=3

 

image.pngIf i want to use it in a text component, with variable "prueba_var1" is OK,

 

imagebut if i use the Variable "Interv_1" i have a formula error.

 

imageI don't understand why.....

 

Thanks in advance

 

 

 

 

Hi @juan.gomez12,

 

It looks like Celonis thinks you are referring to a table instead of a simple piece of text/string. You could solve this in two manners:

  1. Add two single quotes around the text in your variable. By doing it here, you prevent also issues in other components.image
  2. In your formula, you could add two single quotes to parse the variable as a string. image

 

Best regards,

Jan-peter

 

 


Thanks a lot Jan-Peter!! And too fast!!

 

Was sooooo easy..... :)

 

Best Regards!


Thanks a lot Jan-Peter!! And too fast!!

 

Was sooooo easy..... :)

 

Best Regards!

Happy to help @juan.gomez12! Please accept the answer to help fellow peers in finding their answers.


Reply