Hi,

I am trying to create a report with the sales comission by vendor. The data comes from Zoho Books but I am unable to do the logic

The sales report has to be like this

- A table with the actual month and the month before

- If the invoice amount on the actual month is more than the previous, the comission is the 10% of the total invoice made by the vendor in the actual month.

Any idea how to do that?

Thanks,