Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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
10 - Fireball

See if this is what you are after.