You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

convert period to a number and use in formula

in Reporting and Analytics for ERP 4 comments

I need to convert the period to a number (e.g. Oct = 1, Nov = 2, etc…) and then use that number in a formula to divide one of the amounts by that number. I was able to create a column that uses conditional formatting to convert the period to a number, but in my formula where i need to access that number, i get an error. Apparently i can't grab that number from Col B because it's not a data column. How do i do this?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!