Skip to Content
0
Former Member
Feb 14, 2011 at 03:24 AM

Run all cost cenetrs

28 Views

Hi ,

We have one existing template and each time user select one cost centers and sending data to data base .

We have 50 cost centers and and single owner for all cost center .

User will select cost center and time and version from CV .

We have nearly 100 rows and each row has separate calculation in this template .

Ex:

GL1 .----


read last year revenue * escalation factor for selected cost center (each cost center has separate escalation factor enter by user in another template ) ..........up to 12 periods .

Now user wants single run for all cost centers with out select each time one cost center and send .

Through script logic it possible but if user wants to change formula frequently , then excel formula is better .

Pls let me know any suggestions run template for all cost centers with single click with out script logic .

regards,

PSR