Problem with formula in the report footer

# Problem with formula in the report footer

• Friday, August 10, 2012 8:10 AM

Hi,

I have a group (with grouping by field "vid") in the crystal report. Within the group, in the group footer I have a sum by field "Iznos" for the group. The sums for both the values for vid (The value "Pri" and "Isp") in the group return correct result.

Then I have several formula fields in the report footer. The first calculates the value of "Iznos" if field vid="Pri" and the result is correct.

But, the second formula in the report footer (which is almost the same as the first one, and differs in the value of field "vid" only) returns wrong result, it returns 0.

Here are the first two formulas in the report footer:

The first one returns the sum of the rows in the group where field "vid" has value "Pri" (returns correct result)

if({DataTable3.vid}="Pri") then Sum ({DataTable3.Iznos}, {DataTable3.vid})

and the formula for the other sum, when vid=Isp is

if({DataTable3.vid}="Isp") then Sum ({DataTable3.Iznos}, {DataTable3.vid})

The bolded formula returns always 0, which is wrong. (Even though within the group for vid=Isp the sum of Iznos is ok, only here in the report footer it is always 0.)

Can anybody help me please what is the problem?

Thank you very much in advance

• Edited by Friday, August 10, 2012 8:11 AM
•

### All Replies

• Saturday, August 11, 2012 2:53 AM
Moderator

Hi There

Thanks for your posting. I am sorry to say this forum is related to SSRS issues not  crystal report