934647 wrote:If you are willing to add % to the value generated with the custom formula, then you can concat it with '%' symbol.
I create a pivot table in OBIEE 11g that have a Measure. Base on the Measure I create a new calculated
item and the custom formula is ($-1-$-2)/$1*100. But the new column and the Measure column need
different data format-the Measure column is number type,the new column need percentage type.