Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I want number should be displayed like this: 3'000 (not: 3,000) in an expression.
I have tried the following expressions, but not working:
=' Material: ' & num(COUNT(DISTINCT([MaterialCount])),'#,##0' , '.' , 'chr(39)')
=' Material: ' & num(COUNT(DISTINCT([MaterialCount])),'#&chr(39)&##0' , '.' , 'chr(39)')
Please help.
Thanks in Advance.
Would you like to go this?
=' Material: ' & Replace(num(COUNT(DISTINCT [MaterialCount]),'#,##0'), Chr(44),Chr(39))
Would you like to go this?
=' Material: ' & Replace(num(COUNT(DISTINCT [MaterialCount]),'#,##0'), Chr(44),Chr(39))
Or this
=' Material: ' & Num(Count(DISTINCT([MaterialCount]), '#''###', '.', Chr(39))