|
OK so I have now found on this site how to almost get what I require!
Rather than create a formula (doh) all I needed to do was right click on the detail field and choose Insert Summary and hey presto, I'm there..almost!
So I now have 4 summary fields, lets call them A, B, C and D.
What I need to do is if C > 0 then display the value C but force D to disply 0 even if D has a value.
I have tried the select expert but cannot work this section out?
Any pointers please?
|