Range appear in grey

[iliaisyah]

Hi all, o, trying to make another range for multibox to select range of the yield

but the error occurs as below

=If((Sum (ActYield)/Sum (Ha))<=5,'Mid',If((Sum (ActYield)/Sum (Ha))>=0,'Low'))

[marcus_sommer · Accepted solution]

An aggregation like sum() needs always a context respectively any dimension to return a valid value for a calculated dimension - therefore it needs to be wrapped within an aggr() like:

aggr(YourExpression, Dim1, Dim2)

whereby Dim1, Dim2 are placeholder for the dimensions in which context it should be calculated.

- Marcus