
1. Re: I want to show the total no of unprofitable days each month.
Nikunj Bhardava Oct 24, 2016 11:27 PM (in response to Uduak Ekaette)Hi Uduak,
You can calculate nonprofit days by using below formulas
NonProfitDays : { FIXED [Order Date] : sum([Profit])<0 }  This will flag each day if it has Negative Profit
NonProfitDays (Count) : Simply count how many days with negative profit using above formula
IF [NonProfitDays] then
[Order Date]
END
I have attached DEMO for your reference. let me know if you still have any doubt.
Hope this helps!
Thanks,
Nikunj

Sample.twbx 1.2 MB


4. Re: I want to show the total no of unprofitable days each month.
Hima vardhan Reddy Pavuluri Oct 25, 2016 12:14 AM (in response to Uduak Ekaette)Hi ,
In the attached screenshot you are already showing Profitable and Non Profitable Days for each month right ?
just use this calculations if you need it :
Profitable : { FIXED [Order Date] : IF SUM([Profit])>0 THEN 1 end }
Non Profitable :{ FIXED [Order Date] : IF SUM([Profit])<0 THEN 1 end }

5. Re: I want to show the total no of unprofitable days each month.
Uduak Ekaette Oct 25, 2016 12:20 AM (in response to Hima vardhan Reddy Pavuluri)Yes the attached screenshot shows profitable and unprofitable days, but I didn't create it. I am trying to create it.

6. Re: I want to show the total no of unprofitable days each month.
Hima vardhan Reddy Pavuluri Oct 25, 2016 12:29 AM (in response to Uduak Ekaette)3 of 3 people found this helpfulUse these calculations to get counts :
Profitable : { FIXED [Order Date] : IF SUM([Profit])>0 THEN 1 end }
Non Profitable :{ FIXED [Order Date] : IF SUM([Profit])<0 THEN 1 end }
Drag these 2 calculations into Columns shelf and drag measure names into color shelf and select suitable colors for values Profitable and Non Profitable values.
attaching the workbook edited in 10 version for reference .

7. Re: I want to show the total no of unprofitable days each month.
Nikunj Bhardava Oct 25, 2016 12:26 AM (in response to Uduak Ekaette)Hi,
Check attached workbook.
Thanks
Nikunj

Sample.twbx 1.2 MB


8. Re: I want to show the total no of unprofitable days each month.
Uduak Ekaette Oct 25, 2016 12:48 AM (in response to Hima vardhan Reddy Pavuluri)Thank you Hima! This is perfect!

9. Re: I want to show the total no of unprofitable days each month.
Uduak Ekaette Oct 25, 2016 12:49 AM (in response to Nikunj Bhardava)Hi Nikunj,
I can't the workbook you attached.
Thanks.
Udy

10. Re: I want to show the total no of unprofitable days each month.
Nikunj Bhardava Oct 25, 2016 12:59 AM (in response to Uduak Ekaette)Ya, its almost same like what Hema did. i changed workbook to 10.0 version. try if you can see it.

Sample.twbx 1.1 MB


11. Re: I want to show the total no of unprofitable days each month.
Uduak Ekaette Oct 25, 2016 2:17 AM (in response to Nikunj Bhardava)Nikunj I have seen the workbook and it's perfect! Thanks a lot!

12. Re: I want to show the total no of unprofitable days each month.
Deepak G S May 18, 2017 3:01 AM (in response to Uduak Ekaette){fixed [order date] : if sum(profit)>0 then 1 else 0 end}  Calculate the profit days  A
{fixed [order date] : if sum(profit)<0 then 1 else 0 end}  Calculate the nonprofit days(negative days)  B
Ratio:
A:B