I've tried every possible way to use the grouping to find the child group average of unit price
This is my parent Group Parent Group in RDLC
and this is the child group Child Group in RDLC
Expression for Child Which is Correct
=FormatNumber(AVG(Fields!UnitPrice.Value), 2)
Expression for Parent which is I don't know what is wrong
=Avg(Fields!UniPprice.Value, "table2_Group9")
Error Message when I'm getting Error in Navision while compiling a navision report
These are the child unit price which is also average of some same sold items Average of Child Items
Expected result for parent should be average of child items should be 13.74 but if I were to use simple avg function I'd get average of all the item which is wrong..
So Please Help me solve this Thank You!
I've read and tried many blog with this same error message but that does not solve the problem