Hello Gurus ,
There is a column in database(Sql server) which is Varchar holding actual values and percentage values too (Its a measure).
ex : North 100
South 12%
My source is basically an FM model. When I test the table in FM , I can able to see both the values. But when I drag the same columns in report studio in crosstab , actual values are visible and percentage values are showing as -- .
Please provide your valuable suggestion to fix this issue.
Note : I have tried Solve order, which doesn't solve the issue.
Environment : Cognos 10.2.1
Package : FM Model
Convert your varchars to numbers. This is best done when the table is loaded, but if you have to you can convert them in the FM query subject.
Measures need to be numbers.