Hello, I am trying to create a custom formula that counts record summary above a value of 1. For example I have a report now that shows a reference number and then the number of units assigned to the reference number.
sample of data in the report:
Number 99-075380 Number of units 1
Number 99-075382 Number of units 3
Number 99-075383 Number of units 1
Number 99-075385 Number of units 1
Number 99-075386 Number of units 2
What i am trying to achieve is creating a formula that will evaluate the group summary and if the number is greater than 1 count it So in the above example I would get a return of 2 since I have two number that have more than 1 unit.
I have tried this using Do While and if then statements but I don't feel that my syntax is right as I always get a fixed value return of 1
I'm not even sure if you can get CR to automatically increment a number variable based upon an evaluation of a count.
Any help would be appreciated.