This content has been marked as final. Show 4 replies
can you please provide a packaged workbook? (Save as .twbx)
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?
perfect - that worked. thank you!