Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
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?
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
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))
Thanks Sunny!!! its working as required.