Jump to content

Publisher Data Merge


Recommended Posts

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

 

 

Affinity Photo 2.5:         Affinity Photo 1.10.6: 

Affinity Designer 2.5:    Affinity Designer 1.10.6:

Affinity Publisher 2.5:   Affinity Publisher 1.10.6:    

Windows 11 Pro  (Version 24H2 Build (26100.2454)

 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Affinity Photo 2.5:         Affinity Photo 1.10.6: 

Affinity Designer 2.5:    Affinity Designer 1.10.6:

Affinity Publisher 2.5:   Affinity Publisher 1.10.6:    

Windows 11 Pro  (Version 24H2 Build (26100.2454)

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.