| Author |
Message |
lowspark
Newbie
Joined: 27 Nov 2019
Location: United States
Online Status: Offline
Posts: 20
|
   Posted: 30 Dec 2019 at 10:31am |
Edited by lowspark - 30 Dec 2019 at 10:32am
|
|
Nothing left to do but Smile, Smile, Smile.
|
 IP Logged |
|
lowspark
Newbie
Joined: 27 Nov 2019
Location: United States
Online Status: Offline
Posts: 20
|
Posted: 30 Dec 2019 at 10:31am |
|
So after adding this to as a new formula:
DistinctCount ({WORKORDER.WORKORDERID},{@Department})
I get this error:
"There must be a group that matches this field."
I created the Formula by typing in "DistinctCount" then adding in by double clicking {WORKORDER.WORKORDERID} then type in + the Double Click @Department. not sure what i am still doing wrong.
|
|
Nothing left to do but Smile, Smile, Smile.
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 30 Dec 2019 at 10:35am |
|
Whatever field you are grouping on for group one needs to go into the formula.
If you are grouping by the original field use it, if you are grouping by your formula field use it. The resulting formula needs to be placed in the group header or footer for it to display the correct value.
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 30 Dec 2019 at 10:42am |
|
Group 1 Department
use DistinctCount ({WORKORDER.WORKORDERID},group 1 field here)
Group 2 Status
use DistinctCount ({WORKORDER.WORKORDERID},{WORKORDER.STATUS})
Also you can just use the insert summary button (Sigma button) and
pick the field as WorkerID
Type as DistinctCount
location = Group 1 (repeat for group 2).
This will insert a summary field into each group footer that you select. You can drag it into the header group header.
|
|
IP Logged |
|
lowspark
Newbie
Joined: 27 Nov 2019
Location: United States
Online Status: Offline
Posts: 20
|
Posted: 31 Dec 2019 at 4:22am |
|
That was it ,, Thank you so much for working through this with me, I truly appreciate it!!!
Type as DistinctCount
location = Group 1 (repeat for group 2).
This will insert a summary field into each Group footer that you select. You can drag it into the header group header.
These are the two parts that i was having trouble with or did not even know they were that important!. Thanks so much
Edited by lowspark - 31 Dec 2019 at 4:24am
|
|
Nothing left to do but Smile, Smile, Smile.
|
|
IP Logged |
|
|
|
