Post Author: prasadkambala
CA Forum: Formula
I have 3 tables named Account,Debit,Credit
IN account table accountId is the primary key, so the table contains data like
In debit and credit tables ACCOUNTID is not primary key,so these table contain data like
DEBIT TABLE CREDIT TABLE
DEBIT.ACCOUNTID DEBIT.AMOUNT CREDIT.ACCOUNTID CREDIT.AMOUNT
11111 20000 33333 30000
11111 30000 33333 10000
now my requirement is, i want to create a formula feild which sums
if(ACCOUNT.ACCOUNTID=DEBIT.ACCOUNTID) then sum(DEBIT.AMOUNT)
else if(ACCOUNT.ACCOUNTID=CREDIT.ACCOUNTID) then sum(CREDIT.AMOUNT)
When i use this formula it is not displaying any rows.
It should print like
11111 5000033333 40000
please slove my problem.
Thanks in advance.