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

Block Creation issue when I used @prior function

Summary:

Hi,

Please help me in creating the block when I am using @prior function.

Requirement is to add the data of previous period for two account and load to current account.

I am using the below formulae to calculate it.

SET CREATEBLOCKONEQ ON;

"Acc1" = @Prior("Acc1")+@prior("Acc2")+@prior("Acc3");
SET CREATEBLOCKONEQ OFF;

And I tried adding @createBlock as well. Still same issue.

If I create manual block also not working.

SET CREATEBLOCKONEQ ON;

"Acc1" = @Prior("Acc1")+@prior("Acc2")+@prior("Acc3");
SET CREATEBLOCKONEQ OFF;

If I create manual block working.

SET CREATEBLOCKONEQ ON;

"Acc1" = @Prior("Acc1")+@prior("Acc2")+"Acc3";

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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