I have a calculated column that displays a 1 if target for employee is met and a 0 if target is not met. When I select show totals for rows, it does not add up all the 1s, instead the total is 1.
As ex: I have 200 1s and 800 0s, row total calculation should be 200, instead it is 1.
Hi @Roger123
can you share the calculation as well as the visual field area?
BR
Formula: ifelse(distinct_count({A_target}) >= avg({Target_adjj}), 1, 0)
Name, Target_adj, A_target, formula
Bob, 8, 6, 0
Carl, 8, 8, 1
Albert, 8, 12, 1
John, 6, 6, 1
Mindy, 8, 8, 1
.
.
Row Totals: NA, 7.84, 5000, 1 (should return total count of 1s)
sorry what i meant was
Rows:
Region
Leadername
Columns
/
Values 3
Target_adj (Avg)
A_target (Count distinct)
Formula
No aggregation for “formula”?
It is (Custom) bc of formula
Can you try to change the total?
Hi Checking in. We have not heard back from you regarding your question.
We’d Still like to help. If we do not hear back in the next 7 days, we Will archive the question.