Dynamics Community Forum Thread Details

Problem with "Suppress row if all zeroes" print control in Management Reporter

I am using the "suppress row if all zeroes" print contol in my row format for a comparative income statement that compares actual vs. budget with a variance column and a variance percentage column. This is the first year that we brought budget numbers into GP from Forecaster since we previously used FRX which brought in the budget numbers directly from Forecaster. I am finding that even if the actual and budget numbers for the period and year-to-date are zero the line still prints if there is a budget loaded for that account in GP. Since some of the accounts that loaded had zeroes in all months I deleted those account numbers from the budget and they no longer appear in the report. However, the accounts that have a zero in January for Actual and Budget still appear.

My percentage variance column contains a few "if then" statements so I am not sure if this is part of the problem. I have included that formula below with C being the Budget column and D being the calculated variance between budget and actual:

IF C = 0 THEN (IF D=0 THEN +0 ELSE (IF D<0 THEN -1 ELSE +1)) ELSE (IF C<0 AND D<0 THEN -D/C ELSE (IF D>0 AND C<0 THEN -D/C ELSE D/C))

Quick Links

Leaderboard