BusinessObjects Board

calculate the sum and percentage of formula field

building reports crystal reports
#1

Hi i have a formula field that has calculated the fix time I now want calculate the percentage fo calls that are under 2 hrs .

The fix time is stored in a formula field in a sub report .

I want to know how to sum the timings of below 2 hrs and then calculate the percentage.

how do i sum a formulae field and pass the variable to a second formula field and then calculate the percentage

sta767 (BOB member since 2018-11-20)

#2

I assume that you want the total in the main report, is that correct? Does the subreport just calculate the value for one record or is it getting multiple fix times?

How this will work depends on the answers to these questions.

-Dell

hilfy :us: (BOB member since 2007-04-16)