Formula help with Percentage

ROBERT PURDY

Summary

Formula help with Percentage

Content

i have a table, body_parts_injured,

date of incident // body part

1/1/2018 // arm

1/3/2018 // arm

1/5/2018 // eye

1/6/2018// eye

1/6/2018 // eye

etc. throughout the year of 2018.

i want to create a formula to show 

count of body_parts_injured/total count for table

so in my simple mind from caption above

arm:  2/5 = 40%

eye: 3/5 = 60%

how do i create a formula to do this? thank you

 

Version

OAC 18

ROBERT PURDY

on the left, i was able to get it to work in a pivot table,but the options:  DISPLAY AS: PERCENT OF      AND PERCENT OF:  ROW VALUES  does not show up in a LINE CHART.  so i am at a loss.

Lalitha Venkataraman-Oracle

Hi Robert, 

If you are on the latest version of OAC, then you can use a 100% stacked bar to see the values as a percentage. 

 

Alternately, if you want to use a line chart and see various "body part" values as a percentage , for every month, you can use the following calculation construct.

cast(Value as Double) /sum( Value by month(date))

 

Hope this helps.

Regards,

Lalitha

 

ROBERT PURDY

Lalitha, your answer worked for me! thank you VERY MUCH! 

and yes, i can also use the STACKED BAR CHART as well. i found that after i posted this and that is a great solution to.

here is what i ended using for my formula:

i had a field called Total_Count which just has a 1 for each row.

Total_Count /sum( Total_Count by month(date_of_incident))

works perfectly!