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

Carsten Rinke carsten.rinke at gmx.de
Mon Jul 21 13:18:39 EDT 2014


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.
>



More information about the gnucash-user mailing list