Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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,
Thank you
try like this
if(networkingdays([POSTING DATE],[Date if Transmittal])<=2,'Within','Over') as PaymentSLA
Hi,
It didnt work. It all fell to within SLA. As per checking the raw data, there should be some over SLA.
Thank you
The function is NetWorkDays(). With proper use, it should work. If you can't get it worked, try to share your sample app here.
try with
if((NetWorkDays([Date of Transmittal],[POSTING DATE])<=2),'Within','Over') as PaymentSLA