Multiply by 0 gives unexpected result

[orangebloss]

I'm calculating costs based on categories and multiplying the delta by a number specified in a variable. It all works well until I try to multiply by  0 to show that there should be no cost, any other positive number works fine - what am I missing?

Pic shows the effect of multiplying H, TE and TT by 0

[BrunPierre]

Hi, I understand you need to replace the negative values with 0, maybe this.

RangeMax(FieldName, 0)

[rwunderlich]

Can you post you expression?

-Rob

[orangebloss · Accepted solution]

Gah! turns out a bracket was in the wrong place, I don't understand the logic of it as all the other calculations worked just not multiplying anything below 0!