# Positive Values from Substraction Formula on Account Schedule

**URL:** <https://www.dynamicsuser.net/t/positive-values-from-substraction-formula-on-account-schedule/22711>\
**Category:** User Forum\
**Created:** [August 20, 2009, 6:46pm UTC](https://www.dynamicsuser.net/t/positive-values-from-substraction-formula-on-account-schedule/22711 "2009-08-20T18:46:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zen\_Bodhi](https://avatars.discourse-cdn.com/v4/letter/z/4bbf92/32.png) [@Zen\_Bodhi](https://www.dynamicsuser.net/u/Zen_Bodhi)\
**Post date:** [August 20, 2009, 6:46pm UTC](https://www.dynamicsuser.net/t/positive-values-from-substraction-formula-on-account-schedule/22711/1 "2009-08-20T18:46:59Z")

</div>

Hello Nav Experts,

How to handle subtraction on Account Schedule when the result of the calculation become positive?

For example:

G/L Acct. Actual(A) Budget(B) Variance (B – A)

12345 -332.08 300 -32.08

Because Variance was formulated as B-A, the value showing on my Account Schedule is 632.08 → 300-(-332.08); not -32.08.

Thank you for your helps.

ZB

---

<div class="post-metadata">

**Author:** ![modric](https://avatars.discourse-cdn.com/v4/letter/m/aeb1de/32.png) [@modric](https://www.dynamicsuser.net/u/modric)\
**Post date:** [August 20, 2009, 7:56pm UTC](https://www.dynamicsuser.net/t/positive-values-from-substraction-formula-on-account-schedule/22711/2 "2009-08-20T19:56:23Z")

</div>

I don’t quite catch your idea - but maybe Analysis by Dimensions / Analysis Views fits better for your needs?

There are several options what to show: Actual, Budget, Variance, Variance %… Take a look at these. And, Budget numbers must mach by sign, if normally G/L account’s balance is negative (means Credit Saldo, as in Income accounts), then Budgeted Amt should be negative, too.
