Are you able to attach some sample data? You either you need to aggregate both sides of the IF/THEN expression or don't aggregate any.
So, this would be a row-level calculation: if [value] >= 200 and [value] <= 400 then [value] end
And this would be an aggregate: if sum([value]) >= 200 and sum([value]) <= 400 then sum([value]) end
I do not understand your 2nd question, for which sample data would help.
Hi Pooja. Thanks! I forget that I don't need to do the sum and let that
aggregation occur when I put the field on rows.
So that works - what I want ultimately is for the percent of total to be
based on the total of that specific category. The percent of total quick
calc distributes the %s amongst the categories and adds up to 100%. I don't
want that. What I want is the % to be based on the value of gotten from
the range over the total of that category. So if a bar chart, the % would
only be based on values on the one bar. I don't want it to be the total of
I got it now - I had to sum the if statement then divide that by total(the same field)
So something like...
Sum( if >= 200 and <=2000 then end) / total(sum())