Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
sbkumar
Creator
Creator

problem in calculating simple percentage in QS

i am facing issue while calculating percentage.

original table

A       B     C     GRANDTOTAL(A+B+C)

1       2     3               6

2       4      2              5

3        1     2               6

NOw output table should be like this

A                   B          C          GT

16.6 %    33.3 %    50 %       100%     

lIKE THIS I NEED TO CALCULATE PERCENTAGE.

1 Reply
Gysbert_Wassenaar

LOAD

     A/(A+B+C) as A

     B/(A+B+C) as B

     C/(A+B+C) as C

     1 as [GRANDTOTAL(A+B+C)]

FROM ...


talk is cheap, supply exceeds demand