Between values

[TomBond77]

Hi experts

the following expression doesn't work. Any ways to script this better or correct?

IF({<[counter] ={">-6"} and [counter] ={"<1"}>}
Sum([Value 1]) / Sum([Value2]))

Many thanks

Tom

[Taoufiq_Zarra]

@TomBond77  are you looking for ?

if([counter] >-6 and [counter] <1,Sum([Value 1]) / Sum([Value2]))

or

Sum({<[counter] ={">-6"} and [counter] ={"<1"}>}[Value 1]) / Sum({<[counter] ={">-6"} and [counter] ={"<1"}>} [Value2]))

[MayilVahanan]

HI @TomBond77 

Try like below

Sum({<[counter] ={">-6 <1"} >}[Value 1]) / Sum({<[counter] ={">-6 <1"} >}[Value2])

[agigliotti]

maybe this:

=sum( {< [counter] = {">-6<1"} >} [Value 1] / [Value2] )

I hope it can helps.

Best regards
Andrea

[TomBond77]

thanks, but I have to modify my script:

Sum({<[value1] ={">0"}>}
{<[Year]={$(=[Year]-1)} >}
[value2])

This one doesn't work, any ideas?

Many thanks

Tom

[agigliotti]

Hello @TomBond77 ,

What is the logic behind the expression?

[MayilVahanan · Accepted solution]

HI @TomBond77 

Try like below

Sum({<[value1] ={">0"}, [Year]={$(=max([Year])-1)} >}[value2])