Forum Discussion
M_nwadibia
Resolver III
3 years agoadd comma separator to numbers
I have a requirement to add (,) separator to 2 digit number or 3 as I have in the screen shot below. I need an expression to achieve this. Any help will be appreciated
- 3 years ago
I used the expression below to solve the comma requirements. I got the hint from the link below
=Replace(Replace(Fields!field1.Value,"1","a"),"0","b")
=Replace(Replace(Fields!Field1.Value,"Test","Test A"),"Test A B","Test C")
M_nwadibia
Resolver III
3 years agoThis is in Reporting service and not Power BI. I need an expression in reporting service to achieve this.
M_nwadibia
Resolver III
3 years agoI used the expression below to solve the comma requirements. I got the hint from the link below
=Replace(Replace(Fields!field1.Value,"1","a"),"0","b")
=Replace(Replace(Fields!Field1.Value,"Test","Test A"),"Test A B","Test C")