

Creator II
2018-04-23
11:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Baseball Stats
Hey everyone - was trying to dazzle my other coaches with some QV charts but I cannot get the expressions right. I'm calculating AVG and OBP, the expressions I'm using are below. What am I forgetting to do?? Thanks in advance.
AVG Expression: =SUM([1b] + [2b] + [3b] +HR)/(AB)
OBP Expression: =SUM([1b] + [2b] + [3b] + HR + BB)/(PA)
The result should be represented as x.xxx
Am I thinking too much like excel?
1,134 Views
1 Solution
Accepted Solutions

MVP
2018-04-23
12:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try in this way may be -
(Sum([1b])+Sum([2b])+Sum([3b])+Sum(
))/Sum(AB)
1,077 Views
3 Replies

MVP
2018-04-23
12:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try in this way may be -
(Sum([1b])+Sum([2b])+Sum([3b])+Sum(
))/Sum(AB)
1,078 Views

MVP
2018-04-23
12:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use Num for result formatting like this -
Num((Sum([1b])+Sum([2b])+Sum([3b])+Sum(
))/Sum(AB),'#,##0.000')
1,077 Views


Creator II
2018-04-23
01:05 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Digvijay - these expressions drive me crazy!
