Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got this formula sum(aggr(minutes_month,machine)/60) and I want to have the hours by month which the machine is available
And when I take table with a row by breakdown only one of these breakdowns got the right hours in the others I've got 0.
TOTAL | .......... | ......... | 500 |
COMPANY A | TOTAL | ......... | 500 |
COMPANY A | MACHINE 1 | TOTAL | 250 |
COMPANY A | MACHINE 1 | BREAK 1 | 0 |
COMPANY A | MACHINE 1 | BREAK 1 | 250 |
COMPANY A | MACHINE 1 | BREAK 1 | 0 |
COMPANY A | MACHINE 2 | TOTAL | 250 |
COMPANY A | MACHINE 2 | BREAK 1 | 0 |
COMPANY A | MACHINE 2 | BREAK 2 | 250 |
The totals are right and I only want to have 250 in all breaks. What do I have wrong?
May be this
Sum(Aggr(minutes_month, machine, company, break))/60
Thanks, Now it adds the totals. I have this table.
TOTAL | .......... | ......... | 1000 |
COMPANY A | TOTAL | ......... | 1000 |
COMPANY A | MACHINE 1 | TOTAL | 500 |
COMPANY A | MACHINE 1 | BREAK 1 | 250 |
COMPANY A | MACHINE 1 | BREAK 1 | 250 |
COMPANY A | MACHINE 1 | BREAK 1 | 250 |
COMPANY A | MACHINE 2 | TOTAL | 500 |
COMPANY A | MACHINE 2 | BREAK 1 | 250 |
COMPANY A | MACHINE 2 | BREAK 2 | 250 |
I would like this other one
TOTAL | .......... | ......... | 500 |
COMPANY A | TOTAL | ......... | 500 |
COMPANY A | MACHINE 1 | TOTAL | 250 |
COMPANY A | MACHINE 1 | BREAK 1 | 250 |
COMPANY A | MACHINE 1 | BREAK 1 | 250 |
COMPANY A | MACHINE 1 | BREAK 1 | 250 |
COMPANY A | MACHINE 2 | TOTAL | 250 |
COMPANY A | MACHINE 2 | BREAK 1 | 250 |
COMPANY A | MACHINE 2 | BREAK 2 | 250 |
May be this
Sum(Aggr(NODISTINCT minutes_month, machine))/60
Mario, did Sunny's last post get everything working as you wished? If so, please be sure to return to the thread and use the Accept as Solution button on the post(s) that helped you get things working as you wanted. This gives credit to the folks helping and lets others that visit the thread know that things actually worked.
Regards,
Brett