get average

[bsbernabe]

Hello There,

     my concern is about the average of the category price, but base on my expression i got wrong average i don't know why can you

help me correct me if i'm wrong. Kindly see the attached file.

here my expressions:

Sum(Aggr(Avg(PRICE), [CATEGORY]))

Screenshot:

Best Regards,

Bing

[luismadriz]

Hi,

Not sure I understand. Why don't you use just simple Avg(PRICE)?

Cheers,

Luis

[rwunderlich]

Forget the aggr. Just use:

Avg(PRICE)

-Rob

[prma7799]

Like this???

[luismadriz]

Hi,

Just wondering to know how did you go,

Cheers

Luis

When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others