Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to create counter for a number of projects that have spent value under the budget. I decided to use a Text Object for this.
When I do it as a Table Chart, then I can get the number by Summing up the result (3 in the example).
Project | Budget | Spent | Result (1= under, 0=over) |
---|---|---|---|
1 | 100 | 50 | 1 |
2 | 50 | 60 | 0 |
3 | 200 | 10 | 1 |
4 | 150 | 35 | 1 |
TOTAL | 500 | 155 | 3 |
But how can I add it to one expression?
When I use if((Sum(Budget)-Sum(Spent))>0,1,0) in the table it works just fine, but in Text object QV will not know what budgets and spent go together.
Sum(Budget)-Sum(Spent) will give 345 and I cannot count the projects.
Thank you in advance!
Mariliis
hi,
yes it may well be especially if the budget and spent values are coming from the different load.
Try this variation which should get round this:
=sum(if(aggr(Sum(budget)-sum(spent),project)>0,1,0))
I didn't try this first time round as I didn't think it would work but have tried on my dataset and it works whereas the first solution I gave you does not.