Skip to Content
0
Former Member
Jul 09, 2015 at 05:40 AM

Formula for a groupwise field. Kindly help

50 Views

Hi All,

I have grouped all the transaction buy currency Ex below

AUD

Contract1 Balance1 Interest1

Contract2 Balance2 Interest2

Contract3 Balance3 Interest3

USD

Contract1 Balance1 Interest1

Contract2 Balance2 Interest2

Contract3 Balance3 Interest3

Initially I used running total for Balance and Interest then divided by interest/balance. It did not work rather it is only picking last Interest3/balance3.

Kindly help to resolve and let me know if you require further input to resolve this. Thanks