Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm try to get below output using below expression and got null value for one condition can you advise me
aggr(count([Opening SOH]),ArticleNo,Color)/aggr( count(total [Opening SOH]),ArticleNo,Color)
Try this
Dimension
=Aggr(If(Count([Opening SOH])/Count(TOTAL [Opening SOH]) < 0.25, '< 4 Sizes', '>4 Sizes'), ArticleNo, Color)
Expression
Count([Opening SOH])/Count(TOTAL [Opening SOH])
What is your dimension? It seems to be a calculated dimension and I am not sure what that is?
Try this
Dimension
=Aggr(If(Count([Opening SOH])/Count(TOTAL [Opening SOH]) < 0.25, '< 4 Sizes', '>4 Sizes'), ArticleNo, Color)
Expression
Count([Opening SOH])/Count(TOTAL [Opening SOH])