So i am using an NL Table builder to produce a table showing VAT Entry output. It all works fine and i have added an extra column using an excel formula to produce the VAT percentage - Happy with this so far.
What i require is a column to pick up the Entity Name. Ultimately i would like to have multiple Tables underneath each other for all the separate entities and a separate tab using a SUMIF to pick up the Totals per Entity.
When i produce the Column to pick up the Entitiy, i have used the following formula:
This works, however when i run the report my output comes out as:
instead of the actual name of the entity.
What am i doing wrong guys, can anyone please please help?