posted 16 years ago
In a detail field within a JasperReport I need to do a calculation based on two other fields in the same record.
( $F{dwgreld} == null ? ( $F{esthrs} != null ? ( $F{prcntcom} != null ? "MYCALCULATION" : "0" ) : "0" ) : "100" )
The "MYCALCULATION" part needs to give the percentage complete example:
(($F{esthrs} - $F{remhrs})\$F{esthrs})*100
[ November 15, 2007: Message edited by: Steve Dyke ]