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

[Former Member]

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

[Former Member]

Hi Anurag,

use absoute formula and see if it works ,

i.e (CTRL+Shift+Enter ) on the formula cell.

Regards

Ganesh