topic Public holiday and weekends in App Development

Public holiday and weekends

Aspiring_Developer — Wed, 11 Jan 2023 07:52:10 GMT

Hi All,

I have attached the sample Data set .

I am showing the value for a KPI named "On Hand Volume " using below expression :-
Sum({<isLastDayOfMonth={1}>}TREND_VOL)

It is working fine till Nov 2022

What i want to achieve here is that for Dec 2022 it should show the opening value for Jan 2023 .
Also , In jan 2023 , it should show the valu for 3 rd jan as it 1st as 2nd jan 2023 was a public holiday .

It shlould exclude weekedends and Public holidays and show .
Dimension- Trend_Rpeort Date

The value till nov 2022 is fine . However, for Dec 2022 closing value should take the opening value for Jan 2023 .

thanks

Re: Public holiday and weekends

Aamer_17 — Mon, 16 Jan 2023 08:48:18 GMT

Hi,

can you please try with networkdays() function in Data load editor.

Hope this will work.

Thanks,

Re: Public holiday and weekends

Aspiring_Developer — Mon, 16 Jan 2023 09:17:10 GMT

Hi ,

For Network Days , we need two dates . But here I want to implement it on the single date i.e Report Date .

Thanks