What's new in Customer Journeys?

Connect and learn more!
PBCS CALC Script - SET FRMLBOTTOMUP ON; issue — Cloud Customer Connect
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

PBCS CALC Script - SET FRMLBOTTOMUP ON; issue

Accepted answer
40
Views
2
Comments

Summary: calculation not working when SET FRMLBOTTOMUP is ON


Content (required): Hi everyone, I have a calculation script that will calculate expenses based on 3 month historical average. The issue before is that, the calc script takes 10 - 15 mins to calculate. I posted a question on the community before and someone suggested to add SET FRMLBOTTOMUP ON; This improves the calculation by a lot. The problem is when I launch the script and drill to level 0 members, there are some intersections that weren't calculated/not being calculated properly. Code snippet attached

PS: Numbers enclosed on the IF statements are accounts

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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