Total sum per group

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.




Best Answer

  • LejlaLejla Member Posts: 4
    Answer ✓
    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.

Answers

  • LejlaLejla Member Posts: 4
    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
  • LejlaLejla Member Posts: 4
    kr0jmj2z1vhv.png

    dckhluoyyhks.png

  • LejlaLejla Member Posts: 4
    Answer ✓
    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.
Sign In or Register to comment.