Subtotal on negative + positive value > counts the negative as positive

[DevonVanDam]

Hi,

I tried to look at previous topics, but the ones I could find are not really helping me with my problem.

I've column A which tells me if it's a sales or purchase line and then column B gives me the value (always positive - unless return etc.). I made a formula that if column A says sales it should convert the formula against *-1. So my purchases up the stock and sales lower it (thats why negative value). However in my table the subtotal counts the negative and positive, both as a positive:

Formula I use to convert the value is: 

ActualCOMP = IF(

CONTAINS('00 - Master database';'00 - Master database'[Level];"[SALES]");

CALCULATE([Actual]*-1);

CALCULATE([Actual])

)

Does anyone know how to solve this? 

Thanks,

Devon

[dax · Accepted solution]

Hi DevonVanDam, 

You could refer to my sample to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.