We have several transaction list properties with formulas that are now timing out and we are concerned we have hit a ceiling.
The transaction list is just over 6 Million rows and over 60 properties, many of which are calculations.
The formula is a simple as i can make it.
ifblank('Opp Trx'.OWNER_ID.GLOBAL_DIVISION, 'Global Division'."No Segment")
Is the transaction list simply too big or is there a more efficient formula to be used?
I don’t think there is much to do on the formula itself. The best solution is probably to try to do fix this before the import to the transaction list so that values for division is “No Segment” instead of blank in the source data.
An alternative solution is to split your transaction list somehow. If you for example have transactions for your actuals, you can split it in one list for all years before 2026 and one list for 2026 and forward. Then your import will just trigger recalculations in one of your list where you have much fewer rows.
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.
