Worksheet DB Row Summarised - Multiple Values

[spettitt]

I have a worksheet that has summarised database rows. Some of the subrows rows return '---' for some columns, indicating that the summarised rows have differing values, which is fine.

 

But exporting as an excel, the '---' is replaced with '0', which is confusing. Ideally, I'd like to write a formula that returns a specified text string (i.e. 'Multiple'), or at least exported the --- to Excel.

 

I've tried things like: =IFNA(OBJECTDATA('eval circuit destination socket', 'Socket', 'connector'), 'Multiple'), but no joy yet.

 

Is there anything in the current functionality to do this, please? If not, I'll submit a wish for it. Thanks

[Pat Stanford]

I don't believe there is currently a way to do this.