4 Replies Latest reply on Nov 22, 2016 5:23 AM by Andrew Watson

    How to get the no of profitable days in a month?

    Simi TS

      I want to create a view to show the no of profitable days in each month of the year. I have a calculated field to get the profit per day . {  Fixed [Order Date] : Sum([Profit]) }. As per my understanding this will return me the profit for the lowest level detail of order date which is day. Now if [profit per day] > 0 , then its a profitable day, else it is an unprofitable day. Now I want to get a count of all these profitable days in each month. How can I do this please help. i have used the superstores data.