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";
Tagged:
1