if you want to use any measure object in the calculation then it's data type should be number.
For your question to replace dot with comma you can use replace function in webi but after that you will not be abale to do the calculation on the variable.
Var % =Replace(If (IsError([Sales P1]/[Sales P2]*100-100) ;0 ;([Sales P1]/[Sales P2]*100-100));".";",")
Add comment