This content has been marked as final. Show 3 replies
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.
like concat(cast($-1-$-2)/$1*100 as char),'%')
Hope this helps
The new calulate item doesn't use the cast formulate in pivot table.
Is it not possible to create new column in criteria tab with same formula?