Show value for the current month

[Ame]

Hi! I have an agreement column for different projects, and I want to show the agreement for each month on my pivot table, but only for this month, I want to show the agreement divided by the number of working days until today.

What I want to have is:

For the current month=  sum([agreement])/
NetWorkDays(MonthStart(today()),today()) ,

For all the other months: sum([agreement]).

how can I show that in one pivot table?

Regards,

[Ame · Accepted solution]

I fixed my problem by using the expression below,

if([MonthField] >= month(today()),sum([agreement])/NetWorkDays(MonthStart(today()),today()),if([MonthField] < month(today()), sum([agreement]))).