And formula combined with greater than

[tim_leijen]

Hi all,

Just tried to set up an expression where based on two factors QV needs to do come up with volumes.

So basically what I'm saying here, if last year we had volume (either negative or positive) and this year there is also volume (negative or positive), then deduct last years volume of this years volume.

So I created the formula below, but for some reason it doesn't take into consideration the if formula for LY and ACT. Now it's just giving me the difference between both periods.

=IF(sum({<GL_1={VOL},Dimension={LY}>}Data)<>0 AND if(sum({<GL_1={VOL},Dimension={ACT}>}Data)<>0,

sum({<GL_1={VOL},Dimension={ACT}>}Data)-sum({<GL_1={VOL},Dimension={LY}>}Data)

,0))

What am I doing wrong?

[Anil_Babu_Samineni]

Try this way?

=IF(sum({<GL_1={VOL},Dimension={LY}>}Data)<>0 AND sum({<GL_1={VOL},Dimension={ACT}>}Data)<>0,

sum({<GL_1={VOL},Dimension={ACT}>}Data)-sum({<GL_1={VOL},Dimension={LY}>}Data)

,0)

[tim_leijen]

Thanks, but didn't work.... still not taking into consideration the if part

[Anonymous]

try to use addional brackets around the conditional expressions like

=IF((sum({<GL_1={VOL},Dimension={LY}>}Data)<>0) AND (sum({<GL_1={VOL},Dimension={ACT}>}Data)<>0),

sum({<GL_1={VOL},Dimension={ACT}>}Data)-sum({<GL_1={VOL},Dimension={LY}>}Data)

,0)

if still does not work test your expressions step by step using e.g. a textbox

IF(sum({<GL_1={VOL},Dimension={LY}>}Data)<>0,1,0) to test Last year (and maybe select a Dimension)

then test

if(sum({<GL_1={VOL},Dimension={ACT}>}Data)<>0,1,0)

both Expression smust return a 1, then you may test

=IF((sum({<GL_1={VOL},Dimension={LY}>}Data)<>0) AND (sum({<GL_1={VOL},Dimension={ACT}>}Data)<>0),

sum({<GL_1={VOL},Dimension={ACT}>}Data)-sum({<GL_1={VOL},Dimension={LY}>}Data)

,0)