multiplication of account using script logic
My requirement is multiply the head count to salary account from specific time period.
For example user will input salary only for one month like 2015.jan now this salary account value should be multiplied with head count account for each time period of that year, and result should be stored on third account say headcount_exp.
I have hard coded time value in look up but i want time member to be pass from data prompt.
Any other solution for above script?
Cecilia Petersson replied
Sorry for the delay in getting back to you. Try this setup:
Note: I'm adding [PERIOD]='JAN' to the *SELECT statement to ensure only one record is selected as the script doesn't seem to be able to handle several hits for *SELECT. It could be any property as long as you only get one hit