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#Periodic, when I run the report for March 2025, April's balance shows up as the negative YTD balance for 2025.  Is there any kind of conditional formatting I can use that says something like "If the intersection of month and year in the cube view (in this case, April 2025) is larger than the Time POV parameter selected when you run the report (March 2025), then change the text color to White so it doesn't show up? 

 

Reports

1 Reply

  • chul's avatar
    chul
    Contributor III
    26 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.