Hi All,
I have a small problem with a trial balance report, I have 2 sides debit and credit for each account and I do group them in the report and sum the debit side and credit side also I need to put in a variable of the debit blance the deff. between debit-credit which is greater than 0 and in the credit balance the values less than 0 then in the group footer I need sum each one of them to get the totals, I'm trying to use the report variables one of them with condition of IIF(debit-credit>0,balancedebit,0) and the other IIF(debit-credit<0,balancecredit,0) then I need to sum them in the end of the report by normal sum in the field, I tried but no success, any idea about this subject in reports ???? urgent help needed
thanks
Hisham
Best Regards,
Hisham Serry
IT Management