Generate new multiple attributes!!!
There are 3 attributes namely ID LISTINGS CURRENTVALUE...I need to report for every record, LISTINGS which lies between 0.8 and 1.8 of the CURRENTVALUE.
I would hope to generate a new attribute to hold each LISTING whose value lies in the following range(0.8 to 1.8 of the CurrentValue).
Thx
I would hope to generate a new attribute to hold each LISTING whose value lies in the following range(0.8 to 1.8 of the CurrentValue).
Thx
0
Answers
if(CURRENTVALUE>0.8&&CURRENTVALUE<1.8,LISTINGS,"")
Scott
-Shiwaani
ID Listing Current Value
11A ABC 600
12A DEF 400
13A GHI 800
14A JKL 200
15A MNO 1200
Range
.8*CurrentValue 1.8*CurrentValue
480 1080
320 720
640 1440
160 360
960 2160
Desired output
ID Listing Current Value NewVar1 NewVar2 NewVar3
11A ABC 600 ABC GHI
12A DEF 400 DEF ABC
13A GHI 800 GHI MNO
14A JKL 200 JKL
15A MNO 1200 MNO