Reference line for Selected months

[KumaRan]

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)

[mdmukramali]

Hi,

Can you share sample data Application.

Thanks,

Mukram

[shraddha_g]

Share sample app

[KumaRan]

PFA

[Neymar_Jr]

Hi,

Please find attached the updated app.!

Hope it meets your requirement.

Cheers!

[KumaRan]

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?