Publisher Data Merge

[Gnobelix]

Hello everyone,
I have a question about data merging in Publisher.
I have created an Excel sheet where number of pieces, weights, etc., are entered. At the end of the columns, there is a formula for summing up, providing, for example, the total quantity. In columns with no values, Excel typically outputs a sum of zero, which can be hidden.
However, in Publisher, the hidden values are displayed as zeros.
My question is: is there a way in the Publisher to hide these zero values?

Thanks in advance.

Cheers

 

 

[MikeW]

No, there's no function to hide zeros...

A couple things. One is just to F/R in Excel.

Another is to treat the zeros as blank text using the formula that sums the values. Something like:

=""&VLOOKUP(A3,C:D,2,FALSE)

Adjust as needed for your sum formula. The important bit are the empty quotation marks and the ampersand at the beginning of the formula. I haven't tested against APub.

A note. While Excel can hide zeros, they are still there. Which is why APub is displaying them.

[Gnobelix]

34 minutes ago, MikeW said:

No, there's no function to hide zeros...

A couple things. One is just to F/R in Excel.

Another is to treat the zeros as blank text using the formula that sums the values. Something like:

=""&VLOOKUP(A3,C:D,2,FALSE)

Adjust as needed for your sum formula. The important bit are the empty quotation marks and the ampersand at the beginning of the formula. I haven't tested against APub.

A note. While Excel can hide zeros, they are still there. Which is why APub is displaying them.

@MikeW,

Thanks for the reply.

I found a solution to my problem.
The solution:
Enter the following formula in Excel.
=IF(NUMBER(A3:A12);SUM(A3:A12);"")
and not instead of the total

I don't know if the formula is translated correctly into English.
The German formula is (=IF(ANZAHL(A3:A12);SUMME(A3:A12);"")

 

Cheers