I have four columns in the report, one dimension and three fact columns
Fact.Col4 is nothing but I am dividing Col2 and Col3 like this, so in the formula for Fact.Col4, I have this
and these are the settings I have done for Fact.Col4
1. I have overridden the default data format from number to percentage
2. aggregation rule is default
3. have checked "Treat as an attribute column"
So My Fact.col4 has values like this
Now when i am trying to built a graph using the columns dim.Col1 and fact.Col4, then the graph is not getting displayed. It shows me blank. But When I change the data format from percentage to default ( means uncheck the box) then graph comes up. So we can't create a graph on the column for which we have set the data format to percentage.? Can anybody please let me know what am I missing here
The graph comes up when I select this option for the calculated measure column (ex -Fact.Col1/Fact.col2) with the data format as percentage.
Can you just retry ? Please clear the browser cache as well.
Super! It worked. Graph comes back when I select the 1000's separator. But why would that happen? I mean It will be good If I know how did that make any difference. When I selected format to be percentage what is the significance of 1000 separator here? Is that a bug ? Or I am missing anything.