Viewing 2 posts - 1 through 2 (of 2 total)
using Coalesce that has solved it
thanks
June 9, 2011 at 5:31 am
#1336186
CurrentValue1 = 39340.00
CurrentVaule2 = 49340.00
CurrentValue3 = 29370.00
CurrentValue4 = 0 or Null
CurrentValue5 = 0 or Null
....etc
therefore the max point would be the value from CurrentValue3
June 9, 2011 at 4:58 am
#1336168