If [Profit] > 0 Then [Profit]/[Total]
1 of 1 people found this helpful
Hi Pax Gray,
You cannot do the percent of total for a Dimension field. It will be possible only on the measures.
Syntax for calculating the percent of Total: Sum(Measure)/total(sum(measure))
If you have a dimension like Product Name and the measure say Sales. If you would like to calculate the Percent of total for the Product Apple then you can write your calculation like this.
If ATTR( [Product Name]) = 'Apple' then
Please let us know, in case you have any further questions.
Thanks & Regards
I think we almost have it, I'll explain it a little more to see if we can get it right. So I have a dimension and it can be either 'positive' or 'negative'. And I would for it to go something along the lines of: If it is 'positive', then I want to divide the number of 'positive' records by the total number of records. Not sure if this can be done at all now or not. Any ideas?