Forum Discussion

Cheryl_Lamkin's avatar
Cheryl_Lamkin
New Contributor II
2 months ago

Trend Report showing Periodic negative balance for following month

Hi, I am building out a Trend report by year and by product, so I have Jan-Dec along the columns, and then 2022-2025 for each product type by row.  My problem is that because i'm viewing this in V#Pe...
Reports
chul's avatar
chul
Contributor III
28 days ago

Hi Cheryl! Assuming that the highlighted number is the only derived value in the cube view, you can write a condition on either IsRealData = False or IsDerivedData = True to make the text color Transparent should the condition be satisfied.