Summing Up

[macktruck]

Dear Experts,

I have two formulars with me :

The first being

1.

Global numbervar money;

IF {@BPCurrency} <> 'KES' or {@BPCurrency} <> 'EUR'  then

Global numbervar money:= {ConsStatement.Win_FCDeb}

else if {@BPCurrency} = 'KES' or {@BPCurrency} = 'EUR' then

Global numbervar money:= {ConsStatement.Win_SysDeb}

The second being

2.

if {OINV.CurSource} = 'L'
        then {INV1.LineTotal}
 else if {OINV.CurSource} = 'S'
        then {INV1.TotalSumSy}
 else if {OINV.CurSource} = 'C'
        then {INV1.TotalFrgn}

When I try to sum up the first, it does not appear in the list of fields or formulas that can be summed up however the second can be summed up without a problem

There is no difference between them as they are all numerical. What can i do to have the first field name summed up ?

 

[lbass]

If you have "whileprintingrecords" at the beginning of the first formula, remove it. Why are you using a variable here?

What is the content of {@BPCurrency}?

-LB

 

[macktruck]

Hi Lbass,

The BPCurrency is a shared variable from a subreport. I realised this is causing the problem as crystal cannot sum up such. I removed this and the whileprintingrecords and I can now sum up. Thank you for pointing me to the right direction.