Hello wanted to see if anyone could help me with a...
# suiteanalytics
c
Hello wanted to see if anyone could help me with a formula. Currently I'm getting the number of days an RA goes from Pending Refund to Close. This part is working just fine except it is including weekends. Can anyone help me out so this doesn't include weekends? Here is my formula: max(case when {systemnotes.oldvalue} = 'Pending Refund' AND {systemnotes.newvalue} = 'Closed' then {systemnotes.date} end) - max(case when {systemnotes.oldvalue} = 'Pending Receipt' AND {systemnotes.newvalue} = 'Pending Refund' then {systemnotes.date} end)