I’ve got a revenue report which is working just fine until I add a line for FYTD revenue using the RunningValue. This works fine until there are future entries for the FY (essentially don’t exist in the query). In the report I get phantom entries from the first FY returned in the query and I can’t work around it no matter what I try.
Here’s what I get w/o the RunningValue line:
After adding in the RunningValue row I get:
Any ideas on what’s happening and how to get around it? I’m guessing that it’s just something peculiar to RunningValue and I have to do the FYTD valuation calc within my BAQ somehow but just reaching out to see if someone has encountered this and has a solution.