Crystal Reports Running totals sum in Report Footer

Message

   Hi Lockwell, 

I used the formula in my report 

shared numbervar LA;
shared numbervar xx;

local numbervar dc:=distinctcount({table.field}, {group});
if city = "LA" then LA := LA + dc
else if city = "XX" then xx := xx + dc
  else...
dc

I used the following to display summary at group level

shared numbervar LA;
LA

but for some reasons it is giving me a 0 I belive it is not taking any value from the if clause which we used to get the count.

Thank you for your help lockwell I really appreciate it.

Edited by achandana01 - 03 Dec 2011 at 1:45pm