-
1. Re: Between calculated field?
Matt LuttonDec 12, 2013 9:56 AM (in response to Kiran v)
Something like this may work--you may need to aggregate the Capacity fields, if it makes sense to do that. In that case, you'd just wrap each Capacity field in SUM(), like IF SUM([Capacity])>50... etc
if [Capacity] > 50 AND [Capacity] <=150 then "Small"
elseif [Capacity] > 151 AND [Capacity] <= 250 then "Medium"
elseif [Capacity] > 250 then "Large"
else "none"
end
There may be more efficient ways to write this calculation, but I believe this will work.
-
2. Re: Between calculated field?
Michel Caissie Dec 12, 2013 9:59 AM (in response to Kiran v)1 of 1 people found this helpfulYou have to AND two comparisons
if capacity >50 AND capacity <= 150 then etc,...
Michel
-
3. Re: Between calculated field?
Kiran v Dec 12, 2013 10:23 AM (in response to Matt Lutton)The capacity fields are pre-calculated in the data set and are count distinct or count. Either ways yours or Michel's formula works perfectly. I am able to segregate the capacity into different brackets.
Thanks a bunch Matthew!
-
4. Re: Between calculated field?
Kiran v Dec 12, 2013 10:23 AM (in response to Michel Caissie)Thanks Michel it works.
-
5. Re: Between calculated field?
Matt LuttonDec 12, 2013 10:24 AM (in response to Kiran v)
No problem at all.