I have an Oracle View I have brought into Crystal.
Sample Data is this. There are more CostCenters with consisting of various types:
View:
CostCenter Type Hrs
323 M 10
323 V 20
323 L 30
323 Q 39
I do a running totals for Hrs in my reports. I have 6 running totals variables. M, V, L, Q, R, X That I display on my report grouped by CostCenter. However, if a CostCenter is missing any of the 6 types, nothing is shown in my report under that type column. How can I default it to 0?
I want Crystal to be able to handle this issue. My report can't have blanks scattered throughout my report if a Type doesn't exist for that CostCenter.Create a formula having the code
If Isnull(field)=True then
'0'
else
Field
Showing posts with label consisting. Show all posts
Showing posts with label consisting. Show all posts
Monday, March 26, 2012
Running Totals
Subscribe to:
Posts (Atom)