Skip to Content

Previous year's period data along with Current year Actual & Plan values in COPA Form report.

Nov 20, 2017 at 06:08 PM


avatar image

Hi Gurus.

Could you please help on COPA Form report?

Client had a requirement to see Previous Year-Period’s Plan value in 1st Column along with Current Year – Plan & Actual values in Column 2nd & 3rd Columns respectively.

Ex: Reporting requirement

In order to this I have selected Plan actual indicator & FY Variant Operator "-" & Offset '1' for respective columns.

In 2nd column:

In 3rd column:

Planning: I have done Revenue planning to Products at Profit center level in FY16 & FY17.

I have selected Input parameters:

When I selected all the input parameters – In output values coming only to 2016/Prd

If I selected all the input parameters (except FY) – Output coming 1st and 3rd columns are coming correctly, but in 2nd column representing sum of 2016+2017/Prd values.

If I select the all the input parameters except periods (as Blank) – In output values are coming correctly.

So could you please help me, how can I get the Period wise Plan & Actual values correctly for respective F Yrs.


Shiva T

clmn1.jpg (16.9 kB)
clmn2.jpg (16.6 kB)
input-screen.jpg (14.9 kB)
clmn3.jpg (18.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers