51
Views
3

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

Tagged:

• 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.

• 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