Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
6 - Meteoroid

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
11 - Bolide

See if this is what you are after.