I need to show reference line in chart.following expression is working if i select any one month or 2 or 3 consecutive months. if i select random months answer was not correct. can anyone suggest?
(NetWorkDays(Date(min(Date),'DD-MMM-YYYY'),Date(max(Date),'DD-MMM-YYYY'),$(v_Holiday)) * 8.5))
From the above if i choose apr&may combination- 357
apr& june combination- 535.5(apr+may+june) (but i need to get 348.5 for Apr & june)
Thank you for your time. its working fine. but my question is ,in future if months are added, do i need to modify expression isn't?
If answer for the above question is YES i need to automate it without adding any expression.Kindly can you suggest?