1

Issues with $0 values exported as $ in Excel export of a Publication

Hi,

I have measures in my publication that display values as $0. When I export the publication to Excel, the values appear as just $ without the 0. I have attached screenshots of both the publication view & the exported Excel view. How can I fix the zero missing in the Excel export.

Thanks,

Raveena

1 reply

null
    • Customer Solutions Architect
    • Moshe_Yossef
    • 2 days ago
    • Reported - view

    Hi,

    The reason is likely that the currency format in Pyramid is "$#,#" which in Excel translates to not show zeros.

    Go to the format of the measure (best is that you change it in the model, or in formulate if it's a calculation), and change it to: "$#,#0"
    That will make excel show it as $0

Login to reply

Content aside

  • Status Answered
  • 1 Likes
  • 2 days agoLast active
  • 1Replies
  • 39Views
  • 3 Following