Skip to Content
1

BPS Formula and how to reference a blank 0000000 fiscal year/period?

Nov 18, 2016 at 08:15 PM

95

avatar image
Former Member

This is a FOX forumla question that has me stumped. I think it's very simple, but can't see the error of my ways!

I have the following data
Sales Doc type: Product Group: Fiscal year: Fiscal year/period: Sales amount: Monthly%
TA: 101:2017:0000000: 40000, 0
TA: 101:2017:2017001: 0: 10
TA: 101:2017:2017002: 0: 20
TA: 101:2017:2017003: 0: 30
TA: 101:2017:2017004: 0: 40

(These are all zeros, no oh's)

i would like to multiply the annual amount, here 40,000, and post 10,000, 20,000, 30,000 and 40,000 respectively to periods 2017001 to 2017004. Pretty simple, right?

I have defined a planning formula with the following fields to be changed, which is also the sequence of the operand display for the formula:
Key figure name
Sales document type
Fiscal year/period
Fiscal year
Product group

Here is my parameter group code:
{0AMOUNT, TA, 2017001, 2017, 1001} =
{0AMOUNT, TA, 0000000, 2017, 1001} *
{ZMONTHPCT, TA, 2017001, 2017, 1001}.

This code is OK per the syntax checker, as it is if I use # instead of 0000000 for the fiscal year period. The problem is that when I execute the parameter group NOTHING happens.

What changes can you suggest that would multiply 40,000 sales in January by 10% for January and post the value of 4,000 to period 2017001.

Thanks,

Bob

fox
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers