bpilot
August 23rd, 2007, 03:24 PM
I am trying to write a formula for a report that sums up payments received, both positive and negative amounts.
The issue I am running into is that when I drop the appropriate field as a Summary into the report, it displays a blank field in the details section for each entry that would've appeared if I put that transaction amount field into the report.
Further, I cannot just hide the details and do things in a group section (I tried).
I was wondering if someone could help me with this, I am at my wits end. I can display more information about the fields themselves if necessary
On a similiar note, is there anyway to do a Where clause/command in Crystal formula?
ie sum({x}) where transactioncode = "x"
The issue I am running into is that when I drop the appropriate field as a Summary into the report, it displays a blank field in the details section for each entry that would've appeared if I put that transaction amount field into the report.
Further, I cannot just hide the details and do things in a group section (I tried).
I was wondering if someone could help me with this, I am at my wits end. I can display more information about the fields themselves if necessary
On a similiar note, is there anyway to do a Where clause/command in Crystal formula?
ie sum({x}) where transactioncode = "x"