Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Running total in CR 1

Status
Not open for further replies.

HuseyinEce

Programmer
Jul 14, 2011
21
CA
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
 
You CAN use running totals in the formula editor:

{#LT_50_SLA_MET}%{#LT_50_ALL}

-LB
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top