Skip to Content
0
Former Member
May 21, 2015 at 09:20 PM

Excel supported function (count distinct values in column) not working on dashboard

82 Views

Hi,

I am using below function to find distinct values, this function works fine in excel but not when to use in Dashbaord. Both SUMPRODUCT and COUNTIF are supported functions for dashboard. Please advise if is there any issue with using this function or any other function to get count of Distinct values from the excel column.

=SUMPRODUCT((J6:J100<>"")/COUNTIF(J6:J100,J6:J100&""))


Fyi, I using 4.1 SP5 (recently BO has been upgraded from SP3 to SP5)

Thanks,

Anurag