Joined: 26 Jan 2009
Location: United Kingdom
Online Status: Offline
Posts: 12
Topic: Count within PO Posted: 26 Nov 2019 at 7:09am
I have a report grouped by PO. Within the group there are various order lines each with a Status - C for Complete, P or W if not yet Complete. However I just want to see whether the whole PO is complete - if any of the order lines within it are P or W, I want it to say "Incomplete" at the Summary Group level, and then work out how many POs are completely complete, and how many still have some outstanding lines.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 26 Nov 2019 at 10:10am
GRoup on PO
Create a 'flag' formula to set your vlaue for the row to 1 or 0.
If status in p/w then 1 else 0
sum this for the group level
if your group sum=0 its complete
if your group sum>0 then it is incomplete
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
