on 06-24-2015 12:21 PM
Use this.
=If([Quantity ]<0) Then 0 Else [Quantity ]
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.