Can you help me please with Tableau calculation fields?
I have measure “Leftovers” and dimension “Possibility of accommodation”.
I need to calculate another field – “Possible to accomodate leftovers” with such logic:
IF [Possibility of accommodation] <> “No”
THEN [Leftovers]
END
but this calculation makes values of “Possible to accomodate leftovers” greater than “Leftovers” although it should be less or equal.

Aggregation inside calulation fields helped me in another cases, but now I don’t know how to aggregate dimension “Possibility of accommodation”.

SUM(IF [Possibility of accommodation] <> “No”
THEN [Leftovers]
END)
didn’t help