1 of 1 people found this helpful
Try changing your calculated filed to:
IF [Call Outcome (Outcomes)]='Outcome 1' THEN [Premium]
ELSE 0 END
Then when you place the calculated field on a viz, you can aggregate it using SUM.
A calculated field will effectively create a new column in your data, that contains a value for each row of your data. Meaning that even rows where the Call Outcome is not equal to 'Outcome 1' will still have a value (in this case the value will be 0). After that new column is created, you can treat it like any other column and sum it, or max it, or min it, etc.
If you can post a sample of the data and what you are trying to achieve, we can probably help with more ideas.
Thats seems to have done it. Thank you, I figured I was thinking about this too hard.