Hi @polo87,
Please create a sample analysis with mock data in Arena show casing your problem and post it along with clear notes on what values you are expecting to get for the calculation in couple of instances. This will help community members in helping you.
Regards,
Arun Santhosh
Pr QuickSight SA