Summary field ???

[pancho13]

Hello There Crystal gurus:
I've got a little tricky problem that i can't get an answer for.
How can I create a formula field from a group summary so that I could reduce it from the grand total eg:
Sum all cost from a 'group field' where that group 'gl' field start with "22", then reduce this from the grand total...???

I've tried Sum(fld,condfld,cond) but I've got an error saying "the summary / grand total field could not be created" .... any hints, please!!

 

[TheBlondOne]

Have you tried using a running total and then in the evaluation part of the running total, you can insert you condition in there i.e.

{field} like "22*"

this should then only evaluate records where this condition is true.

You should then be able to subtract this from your grand total.

HTH

 

[lbass]

You could use a running total or, if you don't have row inflation, you could create a conditional formula, as in {@gl22}:

if {table.field} startswith "22" then {table.amt}

Then create a second formula to subtract from your grand total:

sum({table.amt}) - sum({@gl22})

-LB