Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
My table is like this.
BCOD | ORC_CODE | REF_NO | POL_NO | CLA_CODE | ORC_COM_DIFF |
---|---|---|---|---|---|
BA00 | 6297 | BA0014D0028206 | BA00101A000875 | MC | -0 |
BA0014D0028209 | BA00141D0003297 | MC | -0 | ||
BA0014D0028218 | BA00131F001678 | MC | -0 | ||
BA0014D0028224 | BA00071C000841 | MC | -0 | ||
BA0014D0028248 | BA00141X0000270 | MC | 0 | ||
BA0014D0028250 | BA00141X0000271 | MC | -77 | ||
BA0014D0028251 | BA00061C000749 | MC | 0 | ||
BA0014D0028252 | BA00081F001144 | MC | -0 | ||
BA0014D0028270 | BA00141C0001572 | MC | -413 | ||
BA0014D0028275 | BA00131B002391 | MC | -0 | ||
BA0014D0028327 | BA00141W0000097 | MC | 0 | ||
BA0014D0028332 | 04BA1B000300 | MC | 0 | ||
BA0014D0028340 | BA0006HC000026 | FR | 189 | ||
BA0014D0028346 | BA00121A001111 | MC | 0 | ||
BA0014D0028354 | BA00141X0000285 | MC | -0 | ||
BA0014D0028384 | BA0014SS0000295 | SS | -54 | ||
BA0014D0028390 | BA0011CF001000 | FR | 13 | ||
BA0014D0028392 | BA0008TC001454 | TC | 90 | ||
BA0014D0028430 | BA00071C000852 | MC | -0 | ||
BA0014D0028440 | BA00141D0003303 | MC | -0 | ||
BA0014D0028442 | BA00081F001147 | MC | 1 | ||
BA0014D0028449 | BA00141F0001704 | MC | -0 | ||
BA0014D0028456 | BA0010GT000151 | MS | 45 | ||
BA0014D0028457 | BA0008CF000901 | FR | 35 | ||
BA0014D0028471 | BA00141C0001578 | MC | 0 | ||
BA0014D0028495 | BA00131D003156 | MC | 0 | ||
BA0014D0028496 | BA00111F001588 | MC | 0 | ||
BA0014R0064057 | BA00131A001226 | MC | -0 | ||
Total | -172 |
If I want to show only the minus values, how can I do that?
Regards,
Priyantha.
Hi Priyantha,
1. Try with set analysis in a straight chart,
only({<ORC_COM_DIFF={"<0"}>}ORC_COM_DIFF)
2. or in your load statement you can try like this
Load *
from table 1
where ORC_COM_DIFF < 0;
Regards
KC
Hi Priyantha,
1. Try with set analysis in a straight chart,
only({<ORC_COM_DIFF={"<0"}>}ORC_COM_DIFF)
2. or in your load statement you can try like this
Load *
from table 1
where ORC_COM_DIFF < 0;
Regards
KC
Hi,
Try like this
If(Expression < 0, Expression)
Note: Replace Expression with your actual expression (Ex.Sum(ORC_COM_DIFF)), hope this helps you.
Regards,
Jagan.