How to achieve this logic

[sanjujeeboy]

i want to achieve the Actual spend as 3000. Logic: Whenever Target>actual it should show spend for that category 

so for Laptop target>actual so only laptop spend should appear in Actual spend.

Currently what is happening is when i click on Accessories its adding the targets of both mobile and laptop and actuals of mobile and laptop. so combining both together target is becoming greater than actual and im getting Actual spend as 4000.

@sunny_talwar @jagan 

[sunny_talwar]

The information provided is not enough to know what you have (expressions, dimensions, logics etc) to answer your post. Are you able to provide a sample where we can see this?

[sanjujeeboy]

Hi Sunny,

I have attached the QVF file as well as the excel used. I have also described the requirement in the app.

Kindly look into this.

Thanks

@sunny_talwar 

[sunny_talwar · Accepted solution]

Change your expression for Actual Spend to

Sum(Aggr(if(sum({<plan={'Target'}>}values) - sum({<plan={'Actual'}>}values)>0, sum({<plan={'Spend'}>}values) ,0), Phase, Category, Accesory))

[sanjujeeboy]

Thanks Sunny!!! its working as required.