Skip to main content

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.

 

 

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!

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)
 

 

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

Reply


Ask your question here!

Terms & ConditionsCookie settings