formula in a cross-tab

[ericb1]

I've searched this forum, and I'm sure this has been done before, but I'm still stuck. Any help is greatly appreciated, thanks!

I have a field I'm trying to calculate. Right now, I'm trying to get it into a cross-tab, but I'm not 100% sure that's how it should be done. I have 3 tables, 2 with a common field of "Claim Type". 1 of the tables has a field of scheduled amount and actual amount (for the claim type)

I'm trying to get the "count" of the number of claims where the actual amount of the claim is greater than the scheduled amount. So I have a formula that says:

{'IRC_sheduled_values_'.Amount} > {Claims.Gross_CEL_Value}

And then I have this in my cross-tab as a summary field as a COUNT, but it just gives me the total number of claims for the grouping, not the count of the formula.

Any help is appreciated, this is Crystal 10, against a SQL db, and I habve several other fields already working correctly in my cross-tab, so I think that's how it should be, but I can take it out of the cross-tab if that's not correct. Thanks!

 

[lbass]

It is just counting the instances of the formula. Change your formula to:

if {'IRC_sheduled_values_'.Amount} > {Claims.Gross_CEL_Value} then 1

Then in the crosstab, add this as your summary field, but use SUM, not count, as the summary.

-LB

 

[ericb1]

YES!! AWESOME! Thank you so much!!