Good morning,
I have a problem with a conditional format applied to the function network days.
The formula is :
Count(distinct{$<[SUBJECT]={"=Networkdays([DATE_A],[DATE_B])>7"}>}[SUBJECT])
//=NetWorkDays(YearStart(Today()), yearEnd(Today()))
The expectation of this formula is to count:
the times in which the number of days between these two fields is major of seven (without considering saturdays and sundays)
The problem I have occurs when I want to apply to this formula =0 or <0, instead of >7
For example:
Count(distinct{$<[SUBJECT]={"=Networkdays([DATE_A],[DATE_B])<0"}>}[SUBJECT])
//=NetWorkDays(YearStart(Today()), yearEnd(Today()))
For =0 i have a result but not sure is correct
for <0 the result is zero.
Is anyone can help me with this formula?
Thanks a lot for your support.