topic Re: logic for field in Application Development and Automation Discussions

logic for field

Former Member — Thu, 11 Dec 2008 07:09:17 GMT

Hi,

I am having one field with name 'Book Value' in Invoice. Book value depends on Excise Number Range.

For example Excise Number Range is 1 - 100000. If Excise No falls between 1 and 50 the Book Value is 1 and If Excise No falls between 51 and 100 the Book Value is 2 and If Excise No falls between 101 and 150 the Book Value is 3 and so on . The book value gets incremented by 1 for the range of 50.

How can i code this. Please suggest.

Thanks

K Srinivas

Re: logic for field

Former Member — Thu, 11 Dec 2008 07:15:21 GMT

divide excise number by 50 then add 1 to the quotient u get. that will be the book value

Re: logic for field

Former Member — Thu, 11 Dec 2008 07:16:46 GMT

If Excise_No between 1 and 50.
Book_Value  = 1.
elseif Excise_No between 51 and 100.
Book_Value  = 2.
.
.
.and so on
ENDIF