Threshold limit for exemption rate of TDS deduction
I have requirement that, Vendor will have lower rate of deduction certificate for WHT Code.
For cumulative invoices till Rs.5 Lacs, I will deduct only 0.5% and after that, I will deduct at 2% (i.e. normal).
For this I am trying formula for calculating WHT. Please look at the screenshot and guide me, how to configure.