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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment