Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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
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?