1 of 1 people found this helpful
Hi Austen Robinson : Could you please elaborate . Do you mean that [Booking Target] is a measure field which has the values :
If yes the formula should be IF [Channel] = "Business" AND [Title] = "SM" THEN sum([Booking Target]) END
Let me know if this is what you are looking for ?
tried your calculation and get an error:
cannot mix aggregate and non aggregate comparisons or results in IF expressions
yes [Booking Target] is a measure.
It depends a bit what you are trying to do with this calculated field. You can probably get what you want with a tweaked version of the formula posted by Rashmi:
IF ATTR([Channel]) = "Business" AND ATTR([Title]) = "SM" THEN SUM([Booking Target]) END