mm7861 (5/7/2015)

---

I've taken a slightly different approach.

I created a calculated column that reversed the sign for the total column if the type ='C'. I then created a measure for this new column and voila!

If the user ever wanted the original totals then they can still use the original total measure. Feels wrong, but works!