Total column incorrect

[Anonymous]

Hi all

Following scenario:

Have a matrix, ROW is a id of an item, COLUMN is a date and VALUE the percentage of total possible bookings this day. (total 1)

The item can be booked multiple times a day, each booking gives me a number of how much this booking is of the total.

For example booking 1 is 0.4 and booking 2 is also 0.4, then this day has a total/value of 0.8.

This works, every day shows the correct sum of these numbers.

But then i need the total percentage for the whole week. Given screenshot shows that the total does not work.

I would expect the total to be 5.17.

I tried sumx but couldnt get it to work..

Thanks in advance

[v-yuta-msft]

@Anonymous ,

Could you please share some sample data and clarify more details about your requirement?

Regards,

Jimmy Tao

[amitchandak]

Can you share the formula

[Anonymous]

There is currently no measure or calc. column in use.

Its just a field from the table.

The sumx formula i tried didnt work, but i never used sumx before so it was just a quick try...

[Anonymous · Accepted solution]

So i tried reproducing it in a sample file, but there its simply just working..

When joining the tables its also working, so i think i will go this way...