Solved

Formula doesn't work (processing time without end)

  • 31 October 2022
  • 3 replies
  • 43 views

Badge

I try a simple formula in a Transaction list of 91.000 items and it doesn’t get the result. It has been updating for 5 minutes, finished and the cells remained empty.

 

 

icon

Best answer by francois 31 October 2022, 15:34

View original

3 replies

Userlevel 5
Badge +5

Hi!
While I can’t explain the time it takes, it looks like the result of your formula is Text-typed while the type of the target property is Number.

Have you tried using the VALUE function? You’d type something like VALUE(LEFT('Market Sales'.Mes, 4))

Hope this helps!

Badge

Hi!
While I can’t explain the time it takes, it looks like the result of your formula is Text-typed while the type of the target property is Number.

Have you tried using the VALUE function? You’d type something like VALUE(LEFT('Market Sales'.Mes, 4))

Hope this helps!

Thank you Francois for your answer! It was referred to a Text-typed (Here I send a clearer image withough so many test columns)
 

 

Userlevel 5
Badge +5

I’m not sure it’s a modeling problem ; could you please submit a support ticket with the relevant details?

Reply