Issue with blank revenue while forecasting

[Kolumam]

Hi All,

I have 5 formulas that compute the forecasted revenue - Operating (USD). The issue is initially when I have all the columns it's showing as blank but when I add a meter reference it's not showing the blank. I couldn't figure out where the blank values are coming from. Please help.

See the first row, where the month is blank and is howing some revenue.

When I add the reference field, the blank in months disappears

Please help. Let me know if you need any other info.

[v-yulgu-msft]

Hi @Kolumam,

It looks like there existing a one to one or one to many relationship between two tables, while the unmatched records between tables cause the Blank value in visual.

Regards,

Yuliana Gu