Worksheet multi records

[Ben3B]

Hello , I'm working on Worksheet to count all "technical" object in my drawing .

I use the criteria in the report as below 

 

And that form in the name cell:

 =CONCAT('TrussItem'.'Name'; 'Lighting Device'.'Symbol Name'; 'Stage Lift'.'LiftType'; 'Soft Goods'.'GdsFunct'; 'Speaker'.'BxModel'; 'Stage Deck'.'DeckSize'; 'BrxHoist'.'HoistID')

 

My problem is, for example, there is no hoist in my event, it add 0 at the end of the item name ... It add a0 for each records who are not present ....
in my example below , 3 records are not present in my event , so in Yellow on the img the 0 i don't wan't to see ...

 

If anybody know hos I can remove it .

May I'm not follwing the good way ... Thanks 🙂

[Pat Stanford]

It looks like the field you are using BrxHoist.HoistID is formatted as a number. Check and see if there is a different field where the ID is stored as text.

 

I think what is happening is that Concat seeing HoistID as a number and since there is no value is assuming the value is zero.

 

Ask again if that is not it.

[Ben3B]

On 8/19/2021 at 11:08 PM, Pat Stanford said:

It looks like the field you are using BrxHoist.HoistID is formatted as a number. Check and see if there is a different field where the ID is stored as text.

 

I think what is happening is that Concat seeing HoistID as a number and since there is no value is assuming the value is zero.

 

Ask again if that is not it.

Thanks for answer, you are true, and I also have the problem with :" 'Soft Goods'.'GdsFunct'; 'Stage Deck'.'DeckSize';'Stage Lift'.'LiftType')"
But stage deck, soft good and stage lift hasn't name function ...

may the concat isn't the good "formule"