Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a QV Doc
it return wrong cal value.
Hope some one can advise me where i go wrong ?
Paul
For your COGS_INT expression, you were using Full Accumulation method, but unfortunately when you use Column(1)/Column(2), it doesn't take the accumulated values, but the original un-accumulated values. A work around is to use no accumulation with RangeSum(Above()) expression:
If(sum(STK_CLOSE) > 0 and sum(STK_OPEN) > 0, RangeSum(Above(Sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (COGS+COGS_INT_)/1), 0, RowNo())))
Once you that the Column(1)/Column(2) calculation is fixed.
For your COGS_INT expression, you were using Full Accumulation method, but unfortunately when you use Column(1)/Column(2), it doesn't take the accumulated values, but the original un-accumulated values. A work around is to use no accumulation with RangeSum(Above()) expression:
If(sum(STK_CLOSE) > 0 and sum(STK_OPEN) > 0, RangeSum(Above(Sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (COGS+COGS_INT_)/1), 0, RowNo())))
Once you that the Column(1)/Column(2) calculation is fixed.
Hi Sunny
Thank you very much for your help.
Paul
Not a problem. I am glad I have been helpful
Hi Sunny
I have another question related to compute the result i need :-
Expression for create each row 30 count total 12 row 360 count ?