i need a variance % of current and previous year data

[eswarchandan]

Is there way to calculate and display a ADs figure (Average Daily Sales) each month

Now for this we would need number of working days.

Would this be worked out via an external Excel sheet which we would populate (need to take into account to exclude weekends and public holidays).

It would display something like the below

[RonaldDoes]

Hi Eswar,

Your image does not show, it's a link to a Gmail-attachment.

Can you upload using the "add image" button in the editor?

[florentina_doga]

use NetWorkDays function

uses NetWorkDays function for automatic calculation of working days

[florentina_doga]

see attach

[eswarchandan]

[techvarun]

Sample data would help here

[eswarchandan]

HI the expression for YTD which iam using ...

sum({<CalendarYear={$(=year(today()))},DateKey={'<=$(v_DFMaxINVDate)'},MonthName=>}Day_TotalNetAmt)

I  need for MTD expression i have tried this but it not working ...

sum({<CalendarYear={$(=year(today()))},MonthOfYear={$(=NUM(Month(Today())))} ,MonthName=>}Day_TotalNetAmt)

thank in advance

[Anil_Babu_Samineni]

Perhaps this?

sum({<CalendarYear={$(=year(today()))},DateKey={">=$(=MonthStart(Max(DateKey))) <=$(v_DFMaxINVDate)'},MonthName=>}Day_TotalNetAmt)