Skip to Content
avatar image
Former Member

Webi round value of sum

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

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

    Add comment
    10|10000 characters needed characters exceeded