Search results for query: *

Yes, i get the zero when getting the value from the database. However, on the report i group per Metric and have an average running total displayed in the group footer which is the values appearing per month. In this running total i evalute each value that is not a zero. This could be my...

Thanx, maybe i wasn't clear enough The report currently displays as follows: P1 P2 P3 P4 ------ P12 YTD Metric-A 90.92 98.5 94.7 Problem 1: P2 has got a "0" value but report shows blank. Problem 2: P4 to P12 needs to stay blank (null values...

Hi, the following formula is not returning the expexted result. I'm using Crystal Reports 9 with MySql as the database. *********************************************************** whileprintingrecords; numbervar intMonths:=0; if Sum ({@Period01}, {SLA_Summary.Metrics}) <> 0 then...

You haven't told us what system and database are involved. If it is "unix time" then you will have to get hold of the u2lpdmtime.dll from the business objects support site. Then simply create a new formula and drag it onto your report: pdmtimetodatetime({table.fieldname})

Hi, i'm battling with the following. In a report containing an array for months of the year we have fields with null values (no data yet. new system, starting from jan2004) with a YTD performance totals after month 12. How do i exclude the monthly totals with null values from the...