Forum Discussion

mueland's avatar
mueland
Frequent Visitor
7 years ago
Solved

Bi-directional filter, SUM issue

Hi,   Trying to understand the filtering in my report. I have two tables where  Table A is my fact table and Table B is dimensions with attributes for WO.No. There are some issues with the quality ...
Need Help
  • mueland's avatar
    mueland
    7 years ago

    Hi!

     

    Thanks for your follow-up and sorry for my late reply. Was not an issue with the sum but in addition to having blank fields my table B was also missing values, so when filtering om blank I was also missing out some orders. Thanks for the follow-up either way! :)

     

     

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi mueland  ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

mueland's avatar
mueland
Frequent Visitor
7 years ago

Hi!

 

Thanks for your follow-up and sorry for my late reply. Was not an issue with the sum but in addition to having blank fields my table B was also missing values, so when filtering om blank I was also missing out some orders. Thanks for the follow-up either way! :)