Anyone have idea how to resolve the decimal number issue when use Aggregated & calculated fields?
Technically... I dont think you can set conditional formatting. However since you're wanting this for a label... why not create a label the way you want it ?
Name: Metric Label
formula like this:
case [Parameters].[Profit Bin Size (copy)]
when 'Sales' then left(str(sum([Sales])),find(str(sum([Sales])),".")-1)
when 'Profit for the Sales' then left(str([Profit]),find(str([Profit]),".")+2)
// I turn the value into a string and then grab the bit I want. There isn't really good formatting formula, but you can sort of build it...
Great Thanks Dana De Jonge. your suggestion is resolved my issue.