All ideas
Aggregate and Odd function
Hello Sir, In the Assignment 4, we have a question in which we have to find sum of total sales after converting it to nearest odd number, which should ignore any subtotals and errors . I am not able to apply ODD and aggregate function together. Kindly suggest how to do this question(9 question) ? As when I am coverting the sales to nearest odd number, then while applying aggregate function, i am getting the subtotals in Total sum also which we don't want.
