Skip to Content
0
Nov 19, 2012 at 09:13 AM

BPCv7.5: Script Logic

32 Views

Hi Experts,

I have come across to a different requirement, in which I have to write a script logic

  1. to sum of all previous 12 periods of an account referring the time in Current View. I cant get this
  2. to send that total value from one application to other application. for this i can use "Destination_app" or "look_up"

in source application, I am to send the data of one account let's say Revenue account (total of all 12 previous periods taking the time in current view as reference for example if i select "2012.NOV" in current view in the action pane, script logic should sum of the values of previous 12 periods (from 2011.NOV to 2012.OCT). If i select "2012.DEC", the system must display total of value of "2011.DEC to 2012.NOV" of the account. this should happen, everytime user changes the time in current view.

If you have any confusion to understand above scenario. Please ask freely. I will try my best to explain it. Please help me out.

Thanks & Regards

Warren