IF condition

[HereWeGoAgain]

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

[anthonyj · Accepted solution]

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

[HereWeGoAgain]

@anthonyj Thank you!