Financial Reports: Perform Column Calculations before Rows

(1) Share

Report

Posted on by TL-07111103-0

Hello,

I would like to know if there is a way to perform column calculations before row calculations in Business Central. I know it was possible to do in D365 FinOps (Report Designer) - but I can't seem to work out how it's possible in BC.

My column definitions are as follows

Column 1

Column 2

Column 3 (Row 1 + Row 2)

My row definitions are as follows

Row 1 = Revenue

Row 2 = Cost of Sales

Row 3 = Row 1 - Row 2 (i.e., Gross Profit)

Row 4 = Row 3 / Row 1 (i..e, Gross Profit %)

Column 3 is adding my Gross Profit %'s together rather than adding the columns first then calculating the percentage.

Sample data to explain what is occuring if it isn't clear from the above.

Any assistance would be great! I feel like I'm missing an easy solution...

Cheers

Tim

Categories:

Business Central

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 73,565 Super User 2024 Season 2 on at

Like (0)

Report

Financial Reports: Perform Column Calculations before Rows

As far as I know, it is not possible, but it may be possible if customized. I'm sorry that I haven't confirmed it in detail.

Hopefully other experts can give you better advice.

Thanks

ZHU