How can I fomat a number output within a Group header so that the numbers appear formatted without decimal places?
Group header formula:
forDaysLate formula
Datediff("d",datevalue({RELFBL.BELEGDATLIEF}) ,datevalue({RELFB.SEGM2_TERM}))
I was hoping that the 'truncate' function would remove the '.00' from the number of days late.
example output:
| number of orders -3.00 days late = |
| number of orders on time = |
| number of orders 5.00 days early = |
If I put the 'forDaysLate' formula in the report, I can format the number using right click -> format field.
How do I do it within a formula??
It would be helpful to remove the negative symbol '-' from the 'days late' number as well.
Any ideas guys?