none
Refer to a Report section by code and use mathematical operation RRS feed

  • Question

  • I have a report that groups cash transactions based on "Received" and "Paid". It works good and grouped them properly, but there is a problem. I want to subtract second group total (Cash Paid) from first group total (cash Received) and get the balance but I don't know are there a way for referring to any group , for example by index or something like this!


    Karim Vaziri Regards,

    Saturday, September 17, 2016 6:12 PM

Answers

  • For example:

    =Sum([Amount]*IIf([Transaction Type]="Cash Received",1,-1))

    where Amount is the field that contains the amount of the transaction and Transaction Type is the field that contains "Cash Received" or "Cash Paid".


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by kvaziri Saturday, September 17, 2016 6:59 PM
    Saturday, September 17, 2016 6:24 PM