Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
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))
for examlpe
apr-170 hrs
may-187 hrs
june-178.5 hrs
July-178.5 hrs
aug-178.5 hrs
Sep-76.5 hrs
From the above if i choose apr&may combination- 357
may&june combination-365.5
apr& june combination- 535.5(apr+may+june) (but i need to get 348.5 for Apr & june)
Hi,
Can you share sample data Application.
Thanks,
Mukram
Share sample app
PFA
Hi,
Please find attached the updated app.!
Hope it meets your requirement.
Cheers!
Hi Rajesh
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?