Relationship issues showing BLANK values

[Tarek78210]

Hi All,

I built a quick model with a lot of rows (10 million). The model analyses the YOY variances per product product group.

A product reference is linked to a product group. In some cases, the data might have mistakes and 1 reference is linked to multiple product groups.

For some reasons, I can see some "(blank)" values and I don't understand why. When I click on the revenue, it shows nothing as if it is empty.

Could you please help?

Thanks so much for your assistance!

[Tarek78210 · Accepted solution]

solved! How can I delete this post?

[Tarek78210 · Accepted solution]

I will but I would like to delete the pictures. I changed the format to numbers in both data tables and that fixed the issue

[Tarek78210 · Accepted solution]

solved! How can I delete this post?

[Wilson_]

Tarek,

Instead of deleting the post, can you share what you did in case anybody runs into this issue in the future? 🙂