Data Action to swing account values

[Thandeka]

Hi Experts

I am new to data actions (script and visual) in SAC. I am tasked with a swing calculations. In simple terms, there are overdraft and cash accounts. The calculation needs to look at the overdraft accounts and check if the sum value in those accounts is positive, it needs to be moved to the cash accounts, and if its negative it stays in the overdraft accounts. Can I get some advice on how to begin this calc? The SAC model is a week model (goes down from Year>>>Quarter>>>Month>>>Week.

Example (YTD values that have been rounded to the nearest 1000
OD500 = 1000
OD600 = -42

The calculation needs to move the 1000 in OD500 and the -42 needs to stay in the OD600

Thank you in advance, experts.