How to calculate Sum and Average of static rows and columns of tables in CRM Dynamics Online

(0) Share

Report

Posted on by Suraj Jadhav

Hello,

I have two entities like Booking and payment List and there is 1:N relationship between them and i am using both Entity fields in my table .

I have group the records in static columns, and i want only those records Sum.

Here is my report preview. it is capturing all records sum. The sum of PSF on carpet area should be 77,400

Please help me in this.

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

David Jennaway 14,065 on at

Like (0)

Report
Copy link

Link copied!

The sum expression is sum(psm_rate_agreedValue) , whereas the value for this column in the detailed rows is an expression, and not the psm_rate_agreedValue field. Try changing the sum to be a Sum of the same expression in that is in the detailed rows

Was this reply helpful? Yes No
Suggested answer

Abby Kong 6 on at

Like (0)

Report
Copy link

Link copied!

Hi Suraj,

Observe the group bracket in front of the row in report editor, Sum[psm_rate_agreedValue] is not in a group, thus this sum is a total not a sub-total for groups.

See below:

Also as David suggested, check the detail row <<Expr>> is psm_rate_agreedValue, we can't tell from the picture.

Regards,

Abby

Was this reply helpful? Yes No
Suraj Jadhav 74 on at

Like (0)

Report
Copy link

Link copied!

Hello ,

If i use detail row in table, that give me multiple records and i don't want that

find below images.

this is report in preview

Was this reply helpful? Yes No
Abby Kong 6 on at

Like (0)

Report
Copy link

Link copied!
Hi Suraj,

Detail rows are useful during development so you get an idea of the actual dataset you are dealing with. If you don't want to show detail rows in your report, simply take it out.

The sample provided earlier is just to show three types:

Detailed Row has a three-dash sign

Aggregated values (SUM, AVG ...) inside a group are inside a group bracket

Aggregated values on Dataset level are not inside any group bracket (like the one in your original post)

Hope this helps.

Regards,

Abby

Was this reply helpful? Yes No