Total sum per group

Lejla

Hi everyone.

I just started with C/AL navision. I want to create simple report thate contains two tables : Sales Invoice LIne and Resurce.

I added a few globas variables , and report looks like this.

(No. is Number of Resource, and at the same time No. of resource in Sales Invoice Line

No. Name Price Qauntity Production Time Value difference
USL001 Resource 1 0.3 5 10 3
USL001 Resource 1 0.3 30 10 8
USL001 Resource 1 0.3 10 10 11

BUT, I want to GROUP By No., and make sum of Quantity and Value Difference.
So my report should look like this:

No. Name Price Qauntity Production Time Value difference
USL001 Resource 1 0.3 45 10 22[/b]

I am new at this, and I really struggle , bcs I dont have enough knowledge.

I would really appriciate if someone could help me.

Lejla

I made it through the layout. I added a parent group and a sum in the field formula that I wanted to display as a sum.

Lejla

I see now that all letter moved to the left so you can not see , i will post two pictures of how report looks right now, and how it should look like

Lejla

Lejla

I made it through the layout. I added a parent group and a sum in the field formula that I wanted to display as a sum.