average over week

[TomBond77]

Hi experts

This formula have an error in expression, how should it be corrected? Thanks!

Avg( {$<[Product Unit]={'Bath rooms'}, Week, [Calendar Day]>} total <Week> [Amount])

[MendyS]

@TomBond77 

what did you try to do?
if you want avg of sum for a specific week so use that - 

Avg ({$< [Product Unit] = 'Bath rooms'}, Week=[SomeWeek]>} [Amount])

if you want to see the avg of Amount by weeks so use that - 

aggr( Avg ({$< [Product Unit] = 'Bath rooms'}>} [Amount]), week)

hope that helps you,
regards

[MendyS]

Avg ({$< [Product Unit] = 'Bath rooms'}, Week=[SomeWeek]>} [Amount])

if you want to see the avg of Amount by weeks so use that - 

aggr( Avg ({$< [Product Unit] = 'Bath rooms'}>} [Amount]), week)

hope that helps you,
regards

[vinieme12]

the expression is fine, 

Question is do all fields in this expression EXISTS? check for misspelled field names

Can you post a full screenshot of the expression editor?