Forum Discussion

FilipFireFlyBI's avatar
FilipFireFlyBI
Icon for Resolver I rankResolver I
7 years ago
Solved

sum rows with a condition

Hi all, See below a preview of my tabel. There are two categories (A and B), the sum of values is 34. Type,Value A, 20 A, 10 B, 4 Total, 34 I want to add Type B to Type A, in the weights of the values...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi FilipFireFlyBI ,

     

    I’m confused about your description. How do you calculate the values of 22.67 for A and 11.33 for B?  If you multiply the value of A by 34 and divide by 30, then how would your B equal 11.33?  is it correct?  The following is my sample data. Can you please share more details and post the accurate output. Then we can help you as soon as possible.

    Best Regards,

    Xue Ding 

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

     

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi FilipFireFlyBI ,

 

I’m confused about your description. How do you calculate the values of 22.67 for A and 11.33 for B?  If you multiply the value of A by 34 and divide by 30, then how would your B equal 11.33?  is it correct?  The following is my sample data. Can you please share more details and post the accurate output. Then we can help you as soon as possible.

Best Regards,

Xue Ding 

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

 

  • vivran22's avatar
    vivran22
    Icon for Community Champion rankCommunity Champion
    7 years ago
    Hi,

    Has this been resolved?

    Rgds,
    Vivek