Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you try this:
Sum({$< Speed = {'$(#vSpeed_Limiter)'}>} If([Speed(Lane 1)] <= vSpeed_Limiter, [Averaged Emissions] * [Flow(Lane 1)]))
Can you try this:
Sum({$< Speed = {'$(#vSpeed_Limiter)'}>} If([Speed(Lane 1)] <= vSpeed_Limiter, [Averaged Emissions] * [Flow(Lane 1)]))
This?
sum({<[Speed(Lane 1)]={'<= $(vSpeed_Limiter)'} , Speed = {'$(#vSpeed_Limiter)'}>} [Averaged Emissions])* [Flow(Lane 1)])