differenc of profit and profit-planned

[schuffe]

Hello ,

I need your help again 😛

I prepared some data:

 

 

Now I want to make a KPI that tells me the differenc of profit and profit planned.

But I dont want "Sum(Profit)-Sum(Profit planned)" (this would be +50 in this example), I need to calculate it in another way, like this: 

That means: For each day and each group I compute the differenc of profit and profit planned, but if the profit is bigger than the profit planned, the differenc has to be zero. 

Long story short:

I need the sum of the differences over all Dates and groups, when the profit is less than planned.

Thanks in advance 🙂

[schuffe · Accepted solution]

With the help of my last post i could solve this by myself :

sum(aggr(if(sum(Profit)-sum([Profit planned])>=0,0,sum(Profit)-sum([Profit planned])),Group,Date))