This content has been marked as final.
Show 4 replies
-
1. Re: calculations on joined tables - distinct rows
Joe Mako Nov 16, 2011 2:47 PM (in response to Jeffery Webb)can you please provide a packaged workbook? (Save as .twbx)
-
2. Re: calculations on joined tables - distinct rows
Jeffery Webb Nov 16, 2011 7:20 PM (in response to Jeffery Webb)here you go ... my bad
-
distinct_join_sample.twbx 15.6 KB
-
-
3. Re: calculations on joined tables - distinct rows
Joe Mako Nov 16, 2011 7:39 PM (in response to Jeffery Webb)What if you change the formula for "number of active users" to
if [status] = 'active' then [first name] end
and the formula for "percent of total" to
COUNTD([number of active users])/countd([first name])
as in the attached?
-
4. Re: calculations on joined tables - distinct rows
Jeffery Webb Nov 18, 2011 5:43 PM (in response to Jeffery Webb)perfect - that worked. thank you!