Skip to Content
0
Jan 04, 2023 at 07:18 PM

Maths Formula to display a value in a string if not blank

46 Views

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?