Showing the number of time 2 different values appearI am working o

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on what looks like a very simple report:
the data is grouped by region and each line shows if someone has paid or not
with the field “paystatus’ having the value Paid or Unpaid. I have to show
the number of people who have paid and those who haven’t by region and then
globally.
I have tried setting a field with a running sum set to Overgroup and all
with a value =count(paystatus). But all it does is showing me the total
number of lines without separating those paid and unpaid.
Can someone help me? Thank you
 
Sylvie said:
I am working on what looks like a very simple report:
the data is grouped by region and each line shows if someone has paid or not
with the field “paystatus’ having the value Paid or Unpaid. I have to show
the number of people who have paid and those who haven’t by region and then
globally.
I have tried setting a field with a running sum set to Overgroup and all
with a value =count(paystatus). But all it does is showing me the total
number of lines without separating those paid and unpaid.
Click to expand...


Then general idea is to use text boxes in the group/report
header/footer with an expression like:

=Sum(IIf(paystatus = "Paid", 1, 0)
 
Back
Top