If or set analysis problem when multiply with cost

[#1]

Hi,

I have a Qlikview beginner problem;

Why is

Sum(Meters*Cost)

working but not

Sum(if(Sorting='Yellow', Meters*Cost)?

Is there a workaround for this?

BR

Johan

[Anonymous]

Hi Johan,

Does it work with an extra " ) " behind it? There is 1 missing.

If not just try something like:

IF(Sorting='Yellow', Sum(Meters*Cost))

That should work.

[#3]

Thank You for a quick reply!

It worked, as a stated "beginners problem"=)

Thank you!