Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

Difference as %

Snowman
Snowman Member ✭✭✭✭
Quicken Premiere 2020, R24.11, Build 27.1.24.11.   A feature that was added was that in comparison reports you could now have the difference between the comparisons shown as a % difference.  (See Below).  I have four questions about the feature.  First, when searching "Help" for this new feature there is very little useful information.  Second, what does INF mean?  I looked in HELP but nothing that I could find.  Third, INF appears when the actual and budget are 0.00, instead of INF shouldn't the percentage be 0.00. Finally, in several instances where the Actual is 0.00, the Budget is an amount say 3.00 and the difference is 3.00 the percentage difference is -100% BUT in another instance (see below) where the actual is 0.00, the budget is 3.00 and the difference is 3.00 the difference is -99.6%  Shouldn't this be -100% as well like the other instances where the actual is 0.00 and the Actual and Difference are the same?
Tagged:

Answers

  • Bob_L
    Bob_L SuperUser ✭✭✭✭✭
    Seems to me that the difference should be as a percentage of budget.  So if the budget is zero, INF would mean infinite or infinity due to division by zero.  The -99.6 one looks like an error to me.
    Quicken Premier Subscription, Windows 10 Home
  • Snowman
    Snowman Member ✭✭✭✭
    Sounds reasonable except in the case where there is an Actual amount but the budget is $0.00 the % difference should be -100% (Expenses, but +100% income)
    not INF because is your budget amount is 0.00 and you spend anything in that category it should be -100%.  Again if it is an income category is should be +100%.

    I just tried an experiment in Excel.  If you divide by 0 I believe that is what triggers the INF error.  The other situation seems to be a bug.  The help file needs to be updated to at least say what INF is and the situations that can cause it.

Sign In or Register to comment.