cancel
Showing results for 
Search instead for 
Did you mean: 

Webi reports Measure Object

Former Member
0 Kudos

Hi experts,

-I m using this Quantity Measure field,

i m getting minus value in this field.

i need to write a formula as if i get minus value then it should 0

is it possible?if so whats the procedure

Accepted Solutions (1)

Accepted Solutions (1)

amitrathi239
Active Contributor
0 Kudos

Use this.

=If([Quantity ]<0) Then 0 Else [Quantity ]

Amit

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi mate,

    This is the Formula, tested!!

IF ( condition; then condition; else condition)

Former Member
0 Kudos

Hi Maya,

If your measure object is not delegated then you can proceed with the simple formula

If([Quantity] < 0) then 0 else [Quantity].

Coz something Delegated measure does not work with this formula.

Former Member
0 Kudos

Hi Maya,

You will have to create a variable with the following condition and use it in report in place of the measure "Quantity". Say the variable name is v_Qty

v_Qty=If([Quantity] < 0) then 0

else [Quantity]

Use this in report.

PS: Take care if you are using calculations on it.

-Ankush