I am trying to edit a report in Crystal Reports 2016 that pulls on a number of database fields only one of which will be valid, whilst the rest are null.
The closest I have got so far is to have a sum including the ABS formula to eliminate the nulls, but that obviously eliminates the +/-
In excel I would have used Value() instead of Abs() - what is the equivilent in Crystal please or an alternative solution please?