# Budget Variance calculation not working **URL:** \ **Category:** Ask the Community\ **Created:** [January 31, 2019, 12:07am UTC](https://pug.phocassoftware.com/t/budget-variance-calculation-not-working/880 "2019-01-31T00:07:39Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![rsavage16](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/rsavage16/32/392_2.png) [@rsavage16](https://pug.phocassoftware.com/u/rsavage16)\ **Post date:** [January 31, 2019, 12:07am UTC](https://pug.phocassoftware.com/t/budget-variance-calculation-not-working/880/1 "2019-01-31T00:07:39Z")
We loaded our sales budget worksheet into our sales database and now trying to compare actual to budget. I followed the directions under this link: ([User documentation home | User documentation](https://help.phocassoftware.com/display/userdoc/Example+-+adding+a+variance+column)) and my variance comes up with all zeros. It doesn’t seem to be calculating correctly. ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/59e12b769e7be29bc09d08726f3006c76e2a2dd1.png) ---
**Author:** ![ShaneAngel](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/shaneangel/32/68_2.png) [@ShaneAngel](https://pug.phocassoftware.com/u/ShaneAngel)\ **Post date:** [January 31, 2019, 1:15am UTC](https://pug.phocassoftware.com/t/budget-variance-calculation-not-working/880/2 "2019-01-31T01:15:53Z")
Have you tried using the Stream mode to achieve this? ---
**Author:** ![StuartH](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/stuarth/32/394_2.png) [@StuartH](https://pug.phocassoftware.com/u/StuartH)\ **Post date:** [January 31, 2019, 9:28am UTC](https://pug.phocassoftware.com/t/budget-variance-calculation-not-working/880/3 "2019-01-31T09:28:32Z")
I’ve checked mine and it works the same as yours. Initially try using stream mode, set the first stream to Sales and the second to Budget. ![BudgetVariance](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/fb87bfd9d449944f0fac2bb1911d605ac831396e.jpeg) Then you can switch to Custom and view how it did it - it’ll be the same as your test. Maybe a stupid question but I presume there are definitely sales in the Current Month? Figures not shown in your screenshot. ---
**Author:** ![rsavage16](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/rsavage16/32/392_2.png) [@rsavage16](https://pug.phocassoftware.com/u/rsavage16)\ **Post date:** [January 31, 2019, 3:38pm UTC](https://pug.phocassoftware.com/t/budget-variance-calculation-not-working/880/4 "2019-01-31T15:38:40Z")
Yes, definitely sales in the current month. So you are getting zeros as well? ---
**Author:** ![rsavage16](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/rsavage16/32/392_2.png) [@rsavage16](https://pug.phocassoftware.com/u/rsavage16)\ **Post date:** [January 31, 2019, 3:45pm UTC](https://pug.phocassoftware.com/t/budget-variance-calculation-not-working/880/5 "2019-01-31T15:45:30Z")
I have not. I’m very new to this and trying to understand the difference between streams (top tabs) and then have the stream, within a stream (does that make sense)? ---
**Author:** ![rsavage16](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/rsavage16/32/392_2.png) [@rsavage16](https://pug.phocassoftware.com/u/rsavage16)\ **Post date:** [January 31, 2019, 7:01pm UTC](https://pug.phocassoftware.com/t/budget-variance-calculation-not-working/880/6 "2019-01-31T19:01:49Z")
I figured it out. We had the budget in the invoice stream. I created a new stream and then also made the budget number a “value”. All good now. Thanks ---
**Author:** ![StuartH](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/stuarth/32/394_2.png) [@StuartH](https://pug.phocassoftware.com/u/StuartH)\ **Post date:** [February 1, 2019, 12:05pm UTC](https://pug.phocassoftware.com/t/budget-variance-calculation-not-working/880/7 "2019-02-01T12:05:39Z")
Glad you got it sorted, I hadn’t even considered you were using database designer to make your own streams.