Hi all
The following is my view code. Why did it show me the result (which were true) only once and never again
SELECT (ROUND((50 * TRATINGTEST.BFUELSPGR) / (LV_LKK.BK / (ROUND(LV_LKK.BK - ROUND(ROUND(0.7 * ROUND(1 - LV_LKK.BK, 4), 4) * 0.25, 4), 4))), 2)) AS BFCR1, ;
SRATINGTEST.IID ;
FROM VSO3!TRATINGTEST ;
JOIN VSO3!SRATINGTEST ;
ON TRATINGTEST.IID = SRATINGTEST.IPID ;
JOIN VSO3VIEWS!LV_LKK ;
ON SRATINGTEST.IID = LV_LKK.IID ;
JOIN VSO3VIEWS!LV_LKFUELCONSTIME ;
ON SRATINGTEST.IID = LV_LKFUELCONSTIME.IID
Please advise.
