May I know how will I excempt weekends for my query below? My condition should only count working days..
if([POSTING DATE]-[Date of Transmittal]<=2,'Within','Over') as PaymentSLA,
try like this
if(networkingdays([POSTING DATE],[Date if Transmittal])<=2,'Within','Over') as PaymentSLA
It didnt work. It all fell to within SLA. As per checking the raw data, there should be some over SLA.
The function is NetWorkDays(). With proper use, it should work. If you can't get it worked, try to share your sample app here.
if((NetWorkDays([Date of Transmittal],[POSTING DATE])<=2),'Within','Over') as PaymentSLA
Retrieving data ...