Is it possible in pivot or straight table

[arulsettu]

hi,

i need to do a calculation in row wise

for example data is like this.     Account and Amount are fields available

ACCOUNT                                                  AMOUNT

Gross premiums                                            100

RI Share of premium-FAC & Prop. TTY            200

XOL Protection costs                                      300

Movement in unexpired premium                      250

what i need is

ACCOUNT                                                  AMOUNT

Gross premiums                                            100

RI Share of premium-FAC & Prop. TTY            200

XOL Protection costs                                      300

Net premium                                                sum of above 3 rows

Movement in unexpired premium                      250

Net earned premium                                    Net premium + Movement in unexpired premium

like this i have to do few more calculations within rows. is this possible to do? or any other alternate ways to do?

please suggest some ideas

Thanks

[#2]

Hi Arul

Pls see attached sample file . hope this helps! please note the data is scrambled so numbers in the app will not add up!

Regards

Sana

[arulsettu]

Hi Sana,

               this is my email id arul.im4@gmail.com

thank you very much