How to do apportionment of tax.

[Karangupta2002]

We need to do the following calculation in alteryx. Please suggest the way forward.

Input VAT credit pertaining to Taxable Supplies (B)

Input VAT credit pertaining to Exempt Supplies (C)

Non-Recoverability Percentage = C/(B+C)

Please let us know, in case you need any further information.

[alexnajm · Accepted solution]

Sounds like a Formula tool! Calculate B and calculate C if the fields aren't available already, then calculate C/(B+C)

[Input VAT credit pertaining to Exempt Supplies] / ([Input VAT credit pertaining to Taxable Supplies] + [Input VAT credit pertaining to Exempt Supplies])

[Raj · Accepted solution]

@Karangupta2002 
the formual tool will solve this problem
1- just check all the columns are in numeric format
2-Create new column "Non-Recoverability Percentage" = [C]/([B]+[C])

hope this help

if this does not work in your case add sample data will help with flow.