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.
Solved
Formula doesn't work (processing time without end)
- Wallflower
Best answer by francois
I’m not sure it’s a modeling problem ; could you please submit a support ticket with the relevant details?
+13- Employee
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!
- Wallflower
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)
+13- Employee
- Answer
I’m not sure it’s a modeling problem ; could you please submit a support ticket with the relevant details?
Log into the Pigment Community
No account yet? Create an account
Single Sign-On Need help?
Log in with your Pigment accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.