Help with the Percentage Calculations

[rajua99]

Hello,

In my report i have need display Revenue and Expenses and i need to apply Group by for revenue and expenses.
I need to calculate the  percentage for each Revenue and Expenses with the Total Revenue.
Because of Group by the percentage for Expenses is always empty. Is there any function in Cognos Report Studio to ignore Group Up and calculate percentage for each expense and display next to it..

I am attaching a screen shot for Example...

Thanks,
Raju

[patrickthatcher]

Not sure you got your answer as I just went through something similar

[Revenue Labor]/ total([Total Revenue] for report)
[Revenue Labor Other]/ total([Total Revenue] for report)
etc

hth