Skip to Content
avatar image
Former Member

Count values

Hi community,

I'ven't got some idea how to correct count values in my table.

Here below my example.

I've got merged column1 (merge by service name) and also got column2 column3

Column(Service Name) Column(Good) Column(Reject)

Test Service 5 6

So the number 6 in column Reject is based by request for all incidents in a period with Count function. The formula is =Count([Rject].[Request1])

By the way actually value y request more than 6. It's about 10. Count function only for original values possible. For me actually count non original values also. I've try to cange formula like =Count([Reject].[Request1];All) and also try to =Count([Reject].[Request1];All) In ([Reject].[Request1]) but unfortunantely the result is not 10.

So my question how to correct count my values with non-original also ?

Add comment
10|10000 characters needed characters exceeded

  • can you share sample data screenshot

  • Former Member

    Thanks for your reply,

    I've found simple workaround by add a new original column to universe table.

    Then I've get values by this unique new column and the fix my formula with it.

    So Count function is completely correct count values

  • Get RSS Feed

0 Answers