Show Amount side by side in report.

zulqzulq Member Posts: 204
Hi,
I have a report which is picking data from a payslip table. I want to display both Allowances and Deductions on same row. Allowances are positive while deductions are negative. Now I want to be able to display both in the report.
Amount > 0                  Amount <0
Any ideas please....


Thanks.
Few years ago we were not existing and few years to come we would be in the grave! So what will benefit us in the grave?

Comments

  • kinekine Member Posts: 12,562
    You can add two textboxes with the amount and use the property "BlankNumbers" on these textboxes - BlankNegAndZero on one, BlankZeroAndPos on second (or BlankNeg and BlankPos if you want to display zero in the textbox).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.