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
edited Jan 18, 2021 6:29AM in Profitability and Cost Management 4 comments


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


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:


Howdy, Stranger!

Log In

To view full details, sign in.


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