on 03-07-2018 6:30 AM
Hello all
I have this data set:
Country shop item value
Japan A 1 12.4
Japan A 2 10.2
Japan A 3 13.7
Japan B 4 9.4
Japan B 5 18.3
Japan B 6 5.7
in my report, there is only the fields "country" and "value". I need to get the sum of rounded value, but with "shop" sub total. That is:
The rounded value of shop A is 36.3 --> 36.
The rounded value of shop B is 33.4 --> 33.
So the report should be like this:
Country Value
Japan 69.
I tried this:
=Round(Sum([value] ForEach([shop]))In([country];0)
But I got the rounded value of all rows together.
Can you help?
Yuval
Try this =Round([value] ForAll ([shop]) In ([country]);0)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.