0

a Column to pick up the name of the Entity

Hi Jeters,

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:

=NP("Formula","P")

This works, however when i run the report my output comes out as:

#NAME?

instead of the actual name of the entity.

 

What am i doing wrong guys, can anyone please please help?

 

Thanks

S2k

0 comments

Please sign in to leave a comment.