0

SSAS Model showing NaN where a zero is expected

NaN Screenshot 08062026 Example for NaN in GWP 08052026_2026-08-06

We have an SSAS model we use in Pyramid and when I look in Pyramid you can see that the value shows NaN.  When I export it to excel the correct number shows which is zero.  Can you explain why it's showing NaN in Pyramid but reflecting the correct number on my Excel Export?

2 replies

null
    • alex_scott
    • 2 days ago
    • Reported - view

    Hi  it looks like the SSAS model is sending Pyramid the measure in scientific notation (-4.65661287307739E-10).  You will need to apply the formatting change inside your multidimensional design tool (like SQL Server Data Tools / Visual Studio for SSAS) this guarantees that the number formats properly across all front-end tools.  

    • Redeemed from the Dark Side (Power BI)
    • Obee1
    • 2 days ago
    • Reported - view

    "NaN" or "not a number" usually shows up when the value is a division by zero. That's what the cube itself would return. The Excel export probably re-interprets this as zero. If so, zero is technically not correct.

Login to reply

Content aside

  • 2 days agoLast active
  • 2Replies
  • 86Views
  • 3 Following