Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I want to create a formula which looks for all outstanding paperwork in %. so the formula will need to look at all oustanding paperwork(at any date range), then taking the value of the oustanding paperwork and then dividing it by current month's revenue.
Oustanding paperwork: LoadSendToInvFlag='N'
Revenue: DrValue
current month: [LoadDate.autoCalendar.Date]
Hope this makes sense.
Thanks in Advance
Hi,
I'm assuming that there are other values in LoadSendToInvFlag so we can use set analysis to limit it to just the 'N'.
The LoadDate is looking at the month of the last load date (ie today(0)) to return your dynamic value.
count({$<LoadSendToInvFlag={'N'}>}[LoadSendToInvFlag]) / sum({$<LoadDate={">=$(=monthstart(today(0)))"}>}DrValue)
I hope this is in the ballpark of what you were looking for.
Regards
Anthony
Hi,
I'm assuming that there are other values in LoadSendToInvFlag so we can use set analysis to limit it to just the 'N'.
The LoadDate is looking at the month of the last load date (ie today(0)) to return your dynamic value.
count({$<LoadSendToInvFlag={'N'}>}[LoadSendToInvFlag]) / sum({$<LoadDate={">=$(=monthstart(today(0)))"}>}DrValue)
I hope this is in the ballpark of what you were looking for.
Regards
Anthony
@anthonyj Thank you!