sum(if( statement

[samuel_brierley]

hi,

cany anyone see an issue with the below formula?

sum(if([Speed(Lane 1)]<= vSpeed_Limiter ,only({$< Speed = {'$(#vSpeed_Limiter)'}>} [Averaged Emissions])* [Flow(Lane 1)]))

all of the individual components work the problem seems to be with the only section however standalone that works too.

thanks

[sunny_talwar · Accepted solution]

Can you try this:

Sum({$< Speed = {'$(#vSpeed_Limiter)'}>} If([Speed(Lane 1)] <= vSpeed_Limiter, [Averaged Emissions] * [Flow(Lane 1)]))

[tresB]

This?

sum({<[Speed(Lane 1)]={'<= $(vSpeed_Limiter)'} , Speed = {'$(#vSpeed_Limiter)'}>} [Averaged Emissions])* [Flow(Lane 1)])