Summaries in formulas

[RealityCheque]

Brief summary: I'm trying to add summaries into formulas using C9.2 and it's not working. Is it possible?

Details: I'm reporting on the status of jobs in our database, and i need to provide a summary of the number of jobs for each status (Open, Completed, Cancelled and Undoable - and yes I know that's not a real word!), with job price and average job price for Open ONLY. Now I know I could suppress each field individually but I'd like to do it in a formula if possible.

"I do not have to forgive my enemies. I have had them all shot."
- Ramon Maria Narvaez

 

[IanWaterman]

You can use summaries in formulae but you must use them where they are created.

If you need to use them in another location, eg a group summary in report footer, you will need to capture value in a Variable, and then use the variable value in your formula.

You have not really given enough information to offer a definitive answer.

Ian

 

[lbass]

Try grouping on status. Then right click on {table.jobID} and insert a summary (count). Then for job price, create a formula:

if {table.status} = "Open" then {table.jobprice}

Place this in the detail section. Right click on the formula and insert a summary (average). You can then right click on both the formula and the summary->format->numbers->customize->check "suppress if zero."

-LB

 

[RealityCheque]

Unfortunantly the figures aren't zero but you've given me an idea for a work-around.

Cheers

"I do not have to forgive my enemies. I have had them all shot."
- Ramon Maria Narvaez

 

[lbass]

The formula will always result in 0 for statuses <> "Open". The summary should be inserted on the formula, not the {table.jobprice} field itself.

-LB