We have a column that is numeric data type in a report but when we go to sum the column, none of the sum, average, etc functions available in the sigma drop down… The only thing that is available is default aggregation and it does nothing. Any ideas?
segerton (BOB member since 2009-05-21)
Is it webI interface ?.
Can you write down how / where do you see these …by writing step by step procedure.
Regards
Ramesh Vasudevan
rameshbalajiv (BOB member since 2008-03-25)
when a measure is setup in the universe as a database delegated measure the sigma button only allows you to choose default aggregation.
When you click on default aggregation it should add a footer to the table block and insert the formula of =[measure]. Usually this should report the words #TOREFRESH since it will need to go out to the database to recalculate the measure at the new level. Can you verify the footer is added and it contains the formula? Try clicking the Refresh All button to see if the value is reported after the report refreshes.
If you don’t want the default aggregation then you can create a variable that applies the appropriate aggregation to the measure and use that variable in your footer.
jbarnes794 
(BOB member since 2008-06-13)
All of this worked. Thank you for the great advice. Steve
segerton (BOB member since 2009-05-21)