#Multivalue when taking out columns

building reports desktopintelligence
1

I have a formula in which looks like this :
X = (([Length Box][Width Box][Height Box])/6000)

So I had a lot of detail in there and now I wanted to take everything out except Country and X, that way I would have a summary of X by country.

But as soon as I took out the packing material (and then the L, W and H) I got multi errors.

How can I amend my formula to look at the packing material of each line and they just sum X.

rpinxt (BOB member since 2019-01-23)

2

Ok…I had a clear moment :wink:

I just used a SUM on X foreach packing material in country.

Looks like it did the trick :slight_smile:

rpinxt (BOB member since 2019-01-23)