Main > Forum > 1C:Enterprise Platform > 1C:Enterprise – Business applications platform > Report - calculate field in current row based on value from previous row

Forum

Search UsersRules
Report - calculate field in current row based on value from previous row
#1
Active user
Points:: 0
Joined:: Sep 16, 2013

Hello

Example of results after generate report action:

Row 1: 100 | 20 | calculate value = 100 - 20 = 80
Row 2: calculate value form above (80) | 60 | 80 - 60 = 20
Row 3: calculate value form above (20) | 10 | 20 - 10 = 10

etc...

Is any way to achive a result such above dynamically calculations based on value from previous row on report?

Thanks in advance

Christoph

Profile
#2
Interested
Points:: 0
Joined:: Dec 4, 2017

Dear kris,

To implement such dynamic calculation in your report, you can build it via the Data Composition System and use a construction like this in the report:

Code
EvalExpression("SUM(<FieldName>)" , , , "First", "Current")


A sample report that implements such functionality is attached.

Best regards,
Vladimir Gurov

Profile
#3
Active user
Points:: 0
Joined:: Sep 16, 2013

Hello,

Vladimir, it works perfectly. Thank you.

Best regards,
Kris

Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.