Skip to main content

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'nREMOVE : 'L9 - P&L'])'FILTER : 'L9 - P&L'='L9 - P&L'."Wallet fees"]
/ 'Wallet Lifetime'mADD : 'L9 - P&L']LBY:'SalesForce opportunities'.'Activity level 2']2FILTER : 'L9 - P&L'='L9 - P&L'."Wallet fees"])"FILTER : CURRENTVALUE >= 0],0),2)

Thanks

Hello ​@Cedric LJ ,

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']
)    
)
    eFILTER: CURRENTVALUE >= 0],
    blank
  ),
  2
)

 


Reply