Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to format the following expression:
=Count(Distinct [Script Number] ) whose value is 26186 to be 26,186 and i am getting errors. How can i accomplish this.
Thanks in advance.
Does this work ?
num( Count(Distinct [Script Number] ), '#,###')
or
num( Count(Distinct [Script Number] ), '#,##0')
Does this work ?
num( Count(Distinct [Script Number] ), '#,###')
or
num( Count(Distinct [Script Number] ), '#,##0')
Many thanks, the trick was on the "Num"
Regards.