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.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!