Want to equally distributes values on report while saving on BPC 10

[former_member187267]

Hi Experts,

I want to distributes values of Dec month  account   equally into Jan to Nov months with script logic on clicking on save button ..please help me that how to do ? any link or source of help ?

[former_member193143]

Hello Pal,

What exactly your requirement ..?

are you entering data in December or the values for December is loaded from Source..?

Please explain your scenario with screen shots then it will be very easy..

Thank you very much

Regards,

Saida Reddy Gogireddy

[former_member187267]

Hi Saida,

Yes there is two requirement first..

1- User will enter data in Dec 2015 -200 and after clicking on save button It will be equally distribute in to 210/11= 19 for Jan 2015 to Nov 2015.

how to achieve it by script logic ....

2-For other report data will be loaded from Source for Dec 2015 but there is no data for Jan 2015 to Nov 2015 so while clicking on save button it should  distribute in to 210/11= 19 for Jan 2015 to Nov 2015 and then save.

Thanks,

Ravi

[former_member186338]

Sorry, Ravi, I do not understand your logic:

After distribution the total year will be 210+210=420??? Is it correct?

Script logic for this strange requirement is:

*WHEN TIME.PERIOD

*IS DEC

*REC(EXPRESSION=%VALUE%/11,TIME=TMVL(-1,%TIME_SET%))

*REC(EXPRESSION=%VALUE%/11,TIME=TMVL(-2,%TIME_SET%))

...

*REC(EXPRESSION=%VALUE%/11,TIME=TMVL(-11,%TIME_SET%))

*ENDWHEN

or using *RUNALLOCATION...

Vadim

[former_member187267]

Hi Vadim,

It will be total value 210 for 11 month which will be equally divided in 11 month  + 210/11 for 12th month so it will be 210+19=229.

Now again i am telling user is entering value in Dec month as 210 and clicking on save

now 210/11 for each month so total it will be 210 +19 =229

not 420.

Thanks,

Ravi

[former_member187267]

Though user is entering as 210 on 12th month it will save as 210/11=19 only for all month including 12th month too...

[former_member186338]

Sorry, but MAY be the correct requirement will be:

When the user enter some value in Dec (ex.:240), then this value has to equally distributed to 12 months Jan-Dec 240/12=20 and the original value in Dec (240) has to be cleared.

user enter:

Dec: 240

Total year: 240

distribution:

Jan-Dec: 240/12=20

Total year: 240

Is it clear?

[former_member187267]

Sorry Vadim but that is not requirement ...

When the user enter some value in Dec (ex.:240), then this value has to equally distributed to 11 months Jan-Dec 240/11=19 and the original value in Dec (240) has to be cleared plus 19 should appear on 12th months too..

user enter:

Dec: 240

distribution:

Jan-Dec: 240/11=19

Total year: 240 + 19

Thanks,

Ravi

[former_member186338]

Are you 100% sure?

It's absolutely strange from the business point of view to plan 12 months (equal values) manually entering value for 11 month... Please explain the reason...

Vadim

[former_member193143]

Hello Ravi,

If I understand you correctly,

User enter the data on December as 240

and its divided by 11 ( 240/11=21.8) and the result has to write to all the 12 months.

The result on the total node is (12*21.8= 261.8)

Is this you are trying to implement...?

as Vadim asked please explain the business reason, its little bit new for me this kind of requirement.

Thank you very much

Saida Reddy Gogireddy

[former_member187267]

Hi Saida,

It is also new for us ..but client is client man i can not force client to change business requirement for logistics service report as per my understanding they have problem in 12th month for scheduling in logi sect that is all.

If possible let me know how to do this by script logic even to use allocation for 12th month how to achieve ?

need to use what ,where ,using and total =1/count ?

Thanks for help

Thanks

Ravi

[former_member186338]

Hi Ravi,

I think there is some misunderstanding between you and client.

About script - I have provided you some sample, is it so hard to adopt it to your requirements?

By the way, disaggregation is better to perform using write back badi, not by script logic in default.lgf.

Vadim

[former_member187267]

Hi Vadim,

Any example for write back badi ?

Thanks,

Ravi

[former_member186338]

Is it so hard to search yourself? Just in How To...

Vadim

[former_member186338]

Sorry, but are you sure to have:

Dec: 110

Save

After:

Jan-Nov: 10

Dec: 110

???

[Former Member]

Hi,

you could use the default logic to run an allocation. The default logic is executed every time data is send to the database.

BR,
Arnold