if else statement

ArndW · Post by **ArndW** » Tue Mar 28, 2006 12:07 pm

Create a stage variable called "DaysDiff" with your date subtraction
In your derivation for column C use

IF DaysDiff < 365 THEN DSLink3.ColC ELSE (DSLink3.ColC*365)/(DaysDiff)

. Note that the answer for a difference of 1096 is the same formula as for => 365.

datastgnewbie · Post by **datastgnewbie** » Tue Mar 28, 2006 1:10 pm

Thanks for the response, but i'm getting an error of Fractional truncation
the field is defined as numeric (18) the number is 852.377 is there a way to fix this?

ray.wurlod · Post by **ray.wurlod** » Tue Mar 28, 2006 3:28 pm

Use Int() function to get the largest integer less than or equal to a particular number.

datastgnewbie · Post by **datastgnewbie** » Tue Mar 28, 2006 3:50 pm

thank-you for the response, i tried that but its not giving me the decimal, I'm going to change the format from numeric to decimal hopefully that will help. thank-you have a good night