How to remove unnecessory values?

[#1]

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.

[jyothish8807 · Accepted solution]

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

[jagan]

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.