Coordinates table worksheet

[MPacheco]

Hello!

 

I've created a coordinate worksheet with Stakes values.

 

I also have stakes that I wanted to see only the Z value.

 

Both coordinates stakes are in different classes.

 

The problem is that I can't "hide" the 0 values, as you can see from the following image.

 

I've tried to use a criteria saying to use only the stakes from the stakes coordinates but the worksheet give me back true and false values, like the following image.

 

Is there any way that I can get the worksheet with only the class stakes coordinates class?

Can anyone give a help? Attached the file with an example and the worksheet.

 

Thanks!!

 

coordinates_worksheet.vwx

Edited June 21, 2022 by MPacheco

[michaelk]

You're so close!

 

You need to change the criteria to include only objects that are stake objects and in the correct class.

 

Right click on cell with the diamond and the 2 > Choose Edit critera.  Make the criteria look like this:

 

 

BTW:  The results you see for =Stake Object.ID and Class = XXXX make sense to the worksheet, if not to humans.  It returns TRUE if there is a value for Stake Object.ID and if the class was correct and FALSE if both item were not true.

coordinates_worksheet~.vwx

[MPacheco]

Thank you mate! Problem solved!