Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.

Summarize the similar data for two different boxes of the return

Neha_Nevrekar
5 - Atom

Hello,

 

Hope you guys are doing well. 

 

May I ask your help regarding a set of data (attached for reference). 

 

We have a tax code set defined for particular transactions. The said transactions are allocated to two boxes of VAT return i.e. Box 3 and Box 9.

 

Can you please help me to allocate the net amount tax codes wise in the respective return boxes (defined below).

 

The mapping should be as below:

Box 3Box 9 
RCP-UAERCP-UAE
RCM-NRReverse Tax - Imports (excludes Travel & Accommodation)
Reverse Tax - Imports (excludes Travel & Accommodation) 

 

In case you need more clarification on the requirement please feel free to drop in. 

 

Thank you!

 

Regards,

Neha

1 REPLY 1
lwolfie
10 - Fireball

See if this is what you are after.