Aggregatins hours in all rows

[marioerro]

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?

[sunny_talwar]

May be this

Sum(Aggr(minutes_month, machine, company, break))/60

[marioerro]

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

[sunny_talwar]

May be this

Sum(Aggr(NODISTINCT minutes_month, machine))/60

[Brett_Bleess]

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