Hello
Could you please tell me how can sort the below formula so I don’t have the time out formula error ?
Formula : roundup(IFBLANK(((('Wallet Lifetime Value'*0.7)[ADD : 'L9 - P&L']-'Input Wallet Upfront'[REMOVE : 'L9 - P&L'])[FILTER : 'L9 - P&L'='L9 - P&L'."Wallet fees"]
/ 'Wallet Lifetime'[ADD : 'L9 - P&L'][BY:'SalesForce opportunities'.'Activity level 2'][FILTER : 'L9 - P&L'='L9 - P&L'."Wallet fees"])[FILTER : CURRENTVALUE >= 0],0),2)
Thanks
Best answer by Stef
Hello
Its quite tough to optimize the formula without all the context but I’ll give it a try!
The issue is the ADD L9, this puts your value on each item of that dimension.
If you use the IFDEFINED as in the example below, it should work more quickly.
If this doesn’t work, please put in a support ticket, as our support team can look directly into your model (if you grant them access)
ROUNDUP(
IFBLANK(
(
(
IFDEFINED('L9 - P&L' = 'L9 - P&L'."Wallet fees",
( 'Wallet Lifetime Value' * 0.7 )
- 'Input Wallet Upfront'
)
/
IFDEFINED('L9 - P&L' = 'L9 - P&L'."Wallet fees",
'Wallet Lifetime'
[BY: 'SalesForce opportunities'.'Activity level 2']
)
)
[FILTER: CURRENTVALUE >= 0],
blank
),
2
)
+12Hello
Its quite tough to optimize the formula without all the context but I’ll give it a try!
The issue is the ADD L9, this puts your value on each item of that dimension.
If you use the IFDEFINED as in the example below, it should work more quickly.
If this doesn’t work, please put in a support ticket, as our support team can look directly into your model (if you grant them access)
ROUNDUP(
IFBLANK(
(
(
IFDEFINED('L9 - P&L' = 'L9 - P&L'."Wallet fees",
( 'Wallet Lifetime Value' * 0.7 )
- 'Input Wallet Upfront'
)
/
IFDEFINED('L9 - P&L' = 'L9 - P&L'."Wallet fees",
'Wallet Lifetime'
[BY: 'SalesForce opportunities'.'Activity level 2']
)
)
[FILTER: CURRENTVALUE >= 0],
blank
),
2
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.