I am facing difficulty in setting up a report.
In a ticket, we have amount1, amount2, amount of refund.
We have 1 more field refund type, it has 2 values partial and full.
If the refund type is full agent enters the amount in "amount of refund". - No problem easy to do.
If the refund type is "Partial" the agent needs to enter values in amount1, amount2 fields.
So, my problem is when I generating report in table format, if refund type is = Partial I need to do sum of amount1 and amount2 and want to display it as amount of refund. Is there any way to do it?
Please sign in to leave a comment.