Trying to add a formula to a CR cross tab report that if the condition is met then count then number of occurences of that string and multiple by 1,000.  I have 9 additional IF statements after the one below.  Can do it in a Pivot table but having trouble in the CR cross tab.

 

if {Status_Pull_110410_442pm.Target} = "1 - $1k+" then count ({Status_Pull_110410_442pm.Target}) * 1000 else