0
Really Bugging me that i cant do this !!
i am trying to show two columns one call visits and one called Pointless visits from a quantity field.
Visits needs to be a count of all records in Qty field and PointlessVisits needs to be a count of records in the qty field that are equal to zero. i want it t0o show as below
|Visits|PointlessVisits|%Pointless|
1000 | 100 | 10%
Can anyone help?
Kingsley-James
Posted 2017-04-08T07:27:43.770
Reputation: 15
You cannot combine different records (some =0 and all the records) – yass – 2017-04-08T14:00:26.127
Is it not possible with a sub query? – Kingsley-James – 2017-04-08T14:27:20.447
If you can create a relation between it – yass – 2017-04-08T14:32:09.413
How would I go about that ? – Kingsley-James – 2017-04-08T14:34:24.817