Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
4 years ago
Solved

% Working out Percentage

Hello i have a table as below, i trying to get the % digital and % Non-Digital  for each week commencing 

 

 

Week Commencing DigitalNon- Digital
01/01/200010050
07/01/20007589
14/01/20005050
   
Need Help
  • sirlanceohlott's avatar
    sirlanceohlott
    4 years ago

    Total Channels = 
SUM('Example Table'[Digital]) + SUM('Example Table'[Non-Digital])

Digital % = 
DIVIDE(
    SUM('Example Table'[Digital]),
    [Total Channels]
)

Non-Digital % = 
DIVIDE(
    SUM('Example Table'[Non-Digital]),
    [Total Channels]
)

     

3 Replies

  • sirlanceohlott's avatar
    sirlanceohlott
    Advocate III
    4 years ago

    Total Channels = 
SUM('Example Table'[Digital]) + SUM('Example Table'[Non-Digital])

Digital % = 
DIVIDE(
    SUM('Example Table'[Digital]),
    [Total Channels]
)

Non-Digital % = 
DIVIDE(
    SUM('Example Table'[Non-Digital]),
    [Total Channels]
)

     

  • sirlanceohlott's avatar
    sirlanceohlott
    Advocate III
    4 years ago

    Hey NewbieJono ,

     

    I'd like to help, so would you, so could you clarify your ask?

     

    You'd like the % of Digital & % Non-Digital in comparison to the prior week?