Skip to Content
0
Sep 10, 2023 at 11:36 AM

Error in SAC RESTRICT, LOOKUP functions

97 Views

Hi Experts,

Please help with this error while trying to build calculations in a SAC analytic model using some ACDOCA fields: Function "RESTRICT" expects parameter 2 to be list of conditions joining with AND. Please complete or rewrite the formula.

I've also look for a workaround using functions: LIKE, SUBSTR but not luck...

I just need be able to make formulas where the calculation be between a range of profit center (acdoca.prctr) and/or a range of account numbers (acdoca.racct).

Thanks!

lookup-error.pngrestrict-error.png

Attachments

lookup-error.png (394.0 kB)
restrict-error.png (390.2 kB)