Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Rule formula to get balance value — 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

Rule formula to get balance value

Received Response
31
Views
11
Comments
in Planning 11 comments

Summary:

In business rule, we need to get the balance value of an account skipping zero and missing.

Content (required):

The business rule needs to get the balance value (skipping zero and missing) of a balance account. The value must be the balance in each month as it is being calculated.

Have tried @RANGELASTVAL, but cannot get it to use a range/xrange with @CURRMBR. Need to be able to cross periods and years to get the latest value up to the month being calculated.

Also tried @PTD but this does not allow specifying the source account crossed with other dimensions.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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