Unable to calculate grand totals

[dev777]

Hi,

I have two groups
Group I - Program
Group II - Type

2007 ratio -> {Val.2007Total}/{Val.2007Count}
2008 ratio -> {Val.2008Total}/{Val.2008Count}

My report looks like this,
----------------------------------------------------
Program Type 2007 ratio 2008 ratio
----------------------------------------------------
Physical Claim 70% 55%
Pending 70% 45%

Marketing Claim 60% 85%
Pending 60% 70%

Totals Claim ?? ??
Pending ?? ??


So, what i did in report footer is
For Claim -> If Uppercase({Val.Type})= "CLAIM" THEN
{Val.2007Total}/{Val.2007Count}

For Pending -> If Uppercase({Val.Type})= "PENDING" THEN
{Val.2007Total}/{Val.2007Count}


But am getting 0% (zeros)

Please reply..

Thanks

 

[lbass]

Create formulas like this:

//{@2007tot}:
if Uppercase({Val.Type})= "CLAIM" THEN
{Val.2007Total}

//{@2007cnt}:
if Uppercase({Val.Type})= "CLAIM" THEN
{Val.2007Count}

//{@Total2007}:
sum({@2007tot})%sum({@2007cnt})

Create similar formulas for "Pending" for 2007 and then create a second set of claim and pending formulas for 2008.

-LB

 

[dev777]

NO, Its not working..
Its also displaying 0(zeros)..

 

[lbass]

Have you tried increasing the decimals and clicking on the % icon?

-LB

 

[dev777]

Yes i did.

 

[lbass]

Please show me what you did in trying to implement my suggestion, as it should work. Show the content of the formulas you used.

-LB

 

[dev777]

Its working..
I apologise for da mess..
I wrote
if Uppercase({Val.Type})= "CLAIM" THEN
Sum({Val.2007Count}) // instead of {Val.2007Count}


Its working fine now... I rectified it...

Thank you very much...

 

[lbass]

You mean you changed it to remove the summary? Because you can't use the summary in the conditional formula and get the correct result.

-LB