You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

PCMCS Custom Calculation Validation Error when using SUM and CROSSJOIN

Accepted answer
21
Views
4
Comments
edited Jan 18, 2021 6:29AM in Profitability and Cost Management 4 comments

Summary

There is a requirement to sum a driver by Entity but based on UDA. Using SUM and CrossJoin function, formula is not getting validated

Content

Hi Experts,

Need some help / info regarding the use of SUM and Cross Join functions in PCMCS Custom Calculation rules. The requirement is to sum a driver by Entity but only for members with a UDA tagged. It throws validation error "Invalid Expression" when I tried the following:

[Adjustment In] := SUM(CROSSJOIN({UDA([Entity],"BlendedDriver")},CROSSJOIN({[Driver]},{[Net Balance]})));

I thought it could be because Rule member not specified, Still same validation error when tried the following:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!