Conditional Running total in CR 1

[HuseyinEce]

Hi,

I have two running total fields. They work fine.
The formula that I use in these two running total fields as below:
1) LT_50_SLA_MET
{SP_CKLB_SBB_Productivity_and_SLA;1.With_in} ='X' and {SP_CKLB_SBB_Productivity_and_SLA;1.SLA_MET} = 1

2) LT_50_ALL
{SP_CKLB_SBB_Productivity_and_SLA;1.With_in} = 'X'

I use type of summary: Count for them

I need to calculate percentage of these two result.

Formula basically (LT_50_SLA_MET / LT_50_ALL) * 100

I can not use these two running total fields in formula editor to apply percentage calculation (LT_50_SLA_MET / LT_50_ALL) * 100

Can anyone tell me how I can do that?

Any help is greatly appreciated,

Thanks

 

[lbass]

You CAN use running totals in the formula editor:

{#LT_50_SLA_MET}%{#LT_50_ALL}

-LB

 

[HuseyinEce]

It works!

Thank you very much and Happy new year.

 

[IdoMillet]

Just to clarify the underlying issue, I suspect it was due to data types.
If {#LT_50_ALL} has a currency data type, while {#LT_50_SLA_MET} is a number, Crystal would indeed complain about it.
Using the % operator bypasses that problem.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com