4 Replies Latest reply on Jun 10, 2016 10:48 AM by Liliya Fisher

Need help with calculation

Liliya Fisher Jun 10, 2016 9:51 AM

Hello,

I want to create a formula that divides distinct count of Event ID from the Concur policy violations data source by Per 10K calculation (calculated by taking total number of count of distinct event ID from Concur-United states data source divided by 10000). However, i don't know how to input the calculation in the calculated formula. I typed countd () event ID/countd()[per 10k]. Thank you

per 10k.PNG 76.7 KB

1. Re: Need help with calculation

pooja.gandhi Jun 10, 2016 10:17 AM (in response to Liliya Fisher)

[Per 10K] is already an aggregate. You can't mix agg/non-agg. So try:

COUNTD([Event ID])/[Per 10K]
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
2. Re: Need help with calculation

Liliya Fisher Jun 10, 2016 10:30 AM (in response to pooja.gandhi)
Hi, i tried it and it didn't work. I captured the error message in the screenshot. Thank you, Liliya

per 10k 2.docx 280.8 KB
Like Show 0 Likes(0)

Actions
3. Re: Need help with calculation

Shawn Wallwork Jun 10, 2016 10:44 AM (in response to Liliya Fisher)

Lillya, Pooja wrote this:

COUNTD([Event ID])/[Per 10K]

You wrote this:

COUNTD( )[Event ID]/[Per 10K]

See the difference?
1 of 1 people found this helpful
Like Show 2 Likes(2)

Actions
4. Re: Need help with calculation

Liliya Fisher Jun 10, 2016 10:48 AM (in response to Shawn Wallwork)

Yes, thank you, got it! Thanks a lot for your help everyone!
Like Show 1 Likes(1)

Actions

Go to original post

Tableau Community Forums

Need help with calculation

1. Re: Need help with calculation

2. Re: Need help with calculation

3. Re: Need help with calculation

4. Re: Need help with calculation

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account