Forum Discussion

MEED_Dubai's avatar
MEED_Dubai
New Member
9 years ago
Solved

Table totals don't add up

The totals don't add the table after I applied filters.  Here are only 21 items on the list yet the count shows 75.  Same happens if I change to Sum.  Still way more than the total on the list. ...
Reports
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    MEED_Dubai

     

    This seems to be related to your table relationship. If you can change the cross filter direction between tblProjects and tblEvents from Single to Both, then we should be able to get the expected result.

     

    Best Regards,
    Herbert

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

MEED_Dubai

 

This seems to be related to your table relationship. If you can change the cross filter direction between tblProjects and tblEvents from Single to Both, then we should be able to get the expected result.

 

Best Regards,
Herbert