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