Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
When i select 2014 Table 1 Day30 , display every row 30 and last row display 360.
How to make Table 2 display :-
when i select year = 2014 , it will display 360
Or this:
If(sum(STK_CLOSE) > 0 and sum(STK_OPEN) > 0, Max(Month(YearMonth))*30)
If(sum(STK_CLOSE) > 0 and sum(STK_OPEN) > 0, IF(Mod(RowNo(),12)=0,360,30))
Or this:
If(sum(STK_CLOSE) > 0 and sum(STK_OPEN) > 0, Max(Month(YearMonth))*30)
Hi Sunny
it work many thank.
Paul