Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
I want to get a figure below 100000 7 above 100000 i try it but not work my normal expression given below. please help me
Sum (GROSSTOT)
sagara
Sorry, I didn't get what you are trying to achieve.
Could you post a screenshot or some sample lines of table records?
In which context do you want to do the calculations? Script? Chart?
THANKS FOR YOUR REPLY
I TRY TO GET FIGURE SEPARATELY FIRST ONE BELOW 100000 & SECOND ONE ABOVE 100000
MY SCRIPT
LOAD BCOD,
CLA_CODE,
PRD_CODE,
POLICY_NO,
REF_NO,
MDATE,
YEAR,
MONTH,
NAME,
ME_CODE,
//TRN_DATE,
DATE(floor(TRN_DATE)) as TRN_DATE,
TRAN_YEAR,
TRAN_MONTH,
POL_PERIOD_FROM,
SCCOD,
CP,
RS,
TC,
GROSSTOT,
N_R_NOS1,
F_NOS2
Maybe like
Result:
LOAD ....
GROSSTOT,
If( GROSSTOT>=10000 and previous(GROSSTOT)< 10000, previous(GROSSTOT) ) as FirstUnder10000,
If(GROSSTOT>=10000 and previous(GROSSTOT)< 10000, GROSSTOT) as FirstAbove10000,
If(Peek(FirstAbove10000) >0, GROSSTOT) as SecondAbove10000
....
RESIDENT YourTable
ORDER BY GROSSTOT asc;
DROP TABLE YourTable;