I have a report, where I want to calculate the lead time into months.
I'm using NAV 2009.
An example is when we have stated that the lead time is 15D (15 days).
I want then to convert D into how much one day is in a month.
Is there any one who have tried this before?
Date
Votes
1 comment
-
Jet Reports Historic Posts Since that isn't really a number, you will probably need to do some sort of IF statement:
=IF((RIGHT(D5,1)="D"), LEFT(D5,FIND("D",D5)-1)/30,"")&" Months" (Where D5 is my lead time, but you could put in a Jet Function in its place)
Determine if the last character is a D, then find the number of Days and divide by 30.
Of course, months have different numbers of days so you could build in some additional logic to determine the number of days in a specific month.
Please sign in to leave a comment.