Essbase Script

Summary

Essbase Script

Content

Hi,

I need help on Calc Scipt writing the script. I have following requirement. Below is the structure of the form which has all 12 months as columns, Accounts in Rows and Entity on Page Drop down. How can i achieve this.

Account	Jan	Feb	Mar	Apr	May	June	Jul	Aug	Sep	Oct	Nov	Dec	Comments
Price1	10	11	12	13	14	60	22	33	44	45	66	77
Price2	20	30	70	55	98	36
Final Price	20	30	70	55	98	36	22	33	44	45	66	77	Need condition that if there is an amount in account Price2 then Final Price = Price2 else Final Price = Price1