|
-
March 21st, 2011, 02:06 PM
#1
How to exclude combinations of certain lines?
I have a report that is grouped twice.
At job then at task. I am trying to excluded when two fields are zero. But I get a mess of results.
A b c
GF2 task1 5 6 0
GF2 task2 0 2 0
GF2 task3 8 0 1
GF2 task4 0 7 2
GF1 Total 13 15 3
How would I excluded line only task2? When A and C are zero?
I tried at the GF2 but task(s) 1, 2 and 4 would disappear if I did " (Sum ({vdvProjectLines.numJobTRXNActlCost}, {vdvProjectLines.chrTaskNumber}) > 0
and Sum ({vdvProjectLines.numJobTRXNRvEstSal}, {vdvProjectLines.chrTaskNumber}) > 0)"
Thanks for your advice.
PN
Last edited by PNorm; March 21st, 2011 at 02:19 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|