Ask Your Question

Accumulation function in base report not working

asked 2018-12-30 22:56:19 +0100

RichardZR gravatar image

Following closely the instructions previously given as a solution in this forum, i.e., Report Builder>insert box [in report footer]>Data Field Type: Function>Data field: Income [in my case]>Function: Accumulation>Scope: Report, I am unable to produce a result. Similarly, no result with minimum or maximum. I have had success with the count function also in getting the last entry amount in the table to show, but no accumulation/total. I have double checked the table field type and tried both "Numeric" and "Decimal" to no avail. I have formatted the numeric data both in the table and report as either general number or currency. And tried with and without grouping. I am using LO version

Any suggestions?

edit retag flag offensive close merge delete


I should also say I am using Mac 10.14.2 (Mohave).

RichardZR gravatar imageRichardZR ( 2018-12-30 23:25:00 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-12-30 23:56:26 +0100

Ratslinger gravatar image


Can't see a problem on Mint 18.3 with same LO version as you state. Did Q&D for test. Table:

image description

Report definition:

image description


image description

No problem also using Minimum or Maximum.

Also tested with & without grouping and results were the same.

edit flag offensive delete link more


Just saw the comment on OS being MAC. Would think this isn't the problem but stranger things.

Ratslinger gravatar imageRatslinger ( 2018-12-30 23:59:23 +0100 )edit

Don't see any bug reports specifically on this matter. If still having problem, suggest you post a sample (no personal/confidential info) for further review.

Ratslinger gravatar imageRatslinger ( 2018-12-31 02:39:51 +0100 )edit

That clarifies, thanks.

RichardZR gravatar imageRichardZR ( 2018-12-31 03:07:31 +0100 )edit

answered 2018-12-31 03:08:11 +0100

RichardZR gravatar image

Accumulate does not tolerate null values. 😔

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-30 22:56:19 +0100

Seen: 26 times

Last updated: Dec 31 '18