This content has been marked as final.
Show 4 replies
-
1. Re: Need help with calculation
pooja.gandhi Jun 10, 2016 10:17 AM (in response to Liliya Fisher)1 of 1 people found this helpful[Per 10K] is already an aggregate. You can't mix agg/non-agg. So try:
COUNTD([Event ID])/[Per 10K]
-
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
-
-
3. Re: Need help with calculation
Shawn Wallwork Jun 10, 2016 10:44 AM (in response to Liliya Fisher)1 of 1 people found this helpfulLillya, Pooja wrote this:
COUNTD([Event ID])/[Per 10K]
You wrote this:
COUNTD( )[Event ID]/[Per 10K]
See the difference?
-
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!