Ask Your Question
0

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 6.1.4.2

Any suggestions?

edit retag flag offensive close merge delete

Comments

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
0

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

Ratslinger gravatar image

Hello,

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

Result:

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

Comments

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
0

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

Stats

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

Seen: 26 times

Last updated: Dec 31 '18