This content has been marked as final.
Show 1 reply
-
1. Re: Creating a custom filter base on Number and Percentage
Tracy RodgersAug 7, 2012 4:45 PM (in response to gilgeraldgonong0)
Hi Gil,
This can be done by using a parameter. Create a string parameter that lists the different formats (i.e. Number, Percentage). Then, using this parameter, create a calculated field using the desired measures. (Note: the measures will need to be converted into strings so that the percentage sign can be applied). For example:
case [Format]
when 'Percentage' then str(round(avg(Discount)*100,2)) + "%"
when 'Number' then str(round(avg(Discount), 3))
end
Then, place this on your view. Finally, right click on the parameter and select Show Parameter Control.
Hope this helps!
-Tracy