Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

formula problem, sometimes don't add the value

Hi everybody,

I'm trying to learn manage this tool (crystal report) I use visual basic 2005 with the crystal for visual basic. Actually I've a problem with some formula fields. My report has several summarize columns (I sum the values) , not all the columns have values so not all the result fields has values. The problem becomes because I have to sum the result fields, and if i do a formula with this:

+ {@horasTinsitu} + {@ConvertirEnSegundosTreal} + {@ConvertirEnSegundosTtaller}

But only works if the three formulas has values, if one formula is empty the result looks empty, I think the problem was in the value of the formulas and I tried to evaluate with u201Cisnullu201D but neither.

Please, somebody has an idea.

Thanks everybody

Well my English it's bad but I think it's possible understand it.

Former Member

Hi Daniel,

Go in each formula and add the following :

If isnull(DatabaseField) Then 0


........Continue your formula steps.

Now you try to add up all formulas and check.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question