How to configure the budget report to put a zero or space in bgt & diff columns

Steve Nospam stevenospam2000 at yahoo.com
Mon Jul 21 14:58:11 EDT 2014


Hmmm, you are correct.  I'm not sure why I had a problem before but I'm really happy that I can work with the exported file as it is!  Thanks.



On Monday, July 21, 2014 12:25 PM, Carsten Rinke <carsten.rinke at gmx.de> wrote:
 


Hi Steve,

I tried today to use the SUM() function in excel to sum up columns with 
periods - result: the periods where ignored.
Isn't this the same on your end?

Kind regards,
Carsten


On 07/21/2014 03:55 PM, Steve Nospam wrote:
> I frequently need to save my budget report to html and then open it in Excel in order to work with the data.  Unfortunately the report places a period (.) in the budget and diff columns if no budget value has been set.  I would prefer a space or a zero so that I can easily sum the column in Excel.  Right now I have to replace all the . values with 0 in order to sum the columns.  I've looked at the options but haven't found a way to accomplish this.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list