I Like PI
New member
- Joined
- Jan 24, 2019
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
I am importing a table and would like to calculate a flag per row... whenever I think Calculated column I tend to want to do the lift as part of the import but regardless I am not sure I how to build this flag in either case.
We have different accrual rules depending on the period spanned ie we have monthly, quarterly, and Annual rules.... actually depending upon the spread a single row might span more than 1 month. I have just decided I want 3 columns. The monthly column is simple enough, if the if Date.EndOfMonth([InvoiceDate])<[GLDate] then "M" else "". Easy peasy... but quarters and annual is a bit tougher. How would I test if the date range between InvoiceDate and GLDate within the row contains quarter ends. (added wrinkle our YE is Oct 31st)
Thoughts?
We have different accrual rules depending on the period spanned ie we have monthly, quarterly, and Annual rules.... actually depending upon the spread a single row might span more than 1 month. I have just decided I want 3 columns. The monthly column is simple enough, if the if Date.EndOfMonth([InvoiceDate])<[GLDate] then "M" else "". Easy peasy... but quarters and annual is a bit tougher. How would I test if the date range between InvoiceDate and GLDate within the row contains quarter ends. (added wrinkle our YE is Oct 31st)
Thoughts?