Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a column called [countall] that has a 1 in every row that I use just for math by the way. I have a normal formula for counting all that are in column [Tier-TierNum] and are '3':
Count({<[Tier-TierNum]={"3"}>}[countall]) = this works perfectly
But they want this count weighted by a factor of 2.22
When I try this it doesn't work:
count({<[Tier-TierNum]={"3"}>}[countall]*2.22)
I can not find the correct aggr syntax to make this work.
Should it be:
= 2.2 * Count({<[Tier-TierNum]={"3"}>}[countall])
Should it be:
= 2.2 * Count({<[Tier-TierNum]={"3"}>}[countall])
Thanks!!!!