Forum Discussion
desktop
Try creating the following measure (not a column):
C =
DIVIDE ( SUM ( dummy[B] ), SUM ( dummy[A] ), 0 )You had the result you wanted in your previous post...
Thanks a lot Wickin for your quick response.
It's working but i tried this but i am expecting the result like row wise like below
want to see the result like this including 92.6% in Red color box expecting all the rows with % and in the end also the same like
A B C
---------------
7 6 85.7%
4 3 75.0%
9 6 66.7%
5 3 60.0%
2 1 50.0%
0 6 00.0%
-----------------
27 25 92.6%
Thanks in advance.
Anonymous wrote:Thanks a lot Wickin for your quick response.
It's working but i tried this but i am expecting the result like row wise like below
Our formulas do that. You might need to turn off summarisation/turn on values with no data in your visual.
Hello JThomson, while using "C = DIVIDE ( SUM ( dummy[B] ), SUM ( dummy[A] ), 0 )" formula i am getting the below result.
with sum on both the columns A, B.
if i apply don't summarise, getting below result
if i use the "C = IF(dummy[A] <> 0, (dummy[B]/dummy[A]), 0)" formula. getting the below results but not able to get as 92.6% as totals under C column. If its fixed. then i am fine..As per the client requiremnt, if A is not equals to 0 then B/A else 0.
Have almost 30 million records are there thats why explainin my senorio with dummy data.
i have taken the Table as visual and if i get the value 92.6% in first ed box with all the rows. Then my met my requirment.
Thanks
Hi JThomson/Wickin ...kindly help on the below to sort out. Thanks in advance
You had the result you wanted in your previous post...
Thanks a lot JThomson and Wickin for the resolution for my issue. It worked well.