Skip to Content
0

Webi round value of sum

Mar 07 at 06:30 AM

23

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Mar 07 at 08:49 AM
0

Try this =Round([value] ForAll ([shop]) In ([country]);0)

Share
10 |10000 characters needed characters left characters exceeded