Hi, I’m trying to run the aged creditor report but would like to see the amounts without the negative sign. Is there any way to blank this out? Regards Kate
Hi Kate You would need to modify the report to display the field in a different manner. I think one way is to set the divisor to -1, but this will naturally show open credits as negative then [:D], which would avoid any confusion if a vendors account was in credit. Sorry I am not from the development side - I am sure they will be able to give you a better answer.
Hi Kate You can change the SourceExpression in the Text Box(s)of the Amount Columns in One of two ways 1. Put Negative sign ‘-’ in front of the existing expressions. ie From TotalAmount to -TotalAmount This just negates/Switches the sign round. 2.Change the expression from TotalAmount to ABS(TotalAmount). This will show all the amounts as a Positive. down side you will not be able to tell the difference between any Negative/Positives.
Stephen and Steven, Thankyou very much for your suggestions. The ABS suggestion offered by Stephen sorted out my problem. Many thanks Kate