Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

SumX / and Multiple Formula Help

Hi Community,   I recently had to move to a new POS system and the data is not the same. So, I have had to reformulate the measures. But I am having a struggle with calculations as it totals it up ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Bump...

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

I download your file and checked your sample. I find all your card will return blank in your sample. What kind of result do you want? I think the data model is complex in your sample. I suggest you to share a easy sample with us and show us a screenshot with the result you want. This will make us easier to find the solution.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Rico,

     

    It's suppose to calcualte based on the total for the families. The old dashboard I was using looks like this.

     

    Now the new one.

    When you select 1 item, the numbers report fine. But when it shows all, you can see how the numbers are not even close.

     

    Hope this helps. Thank you for your support.

    MT