How to make table 2 display 360 ?

[paulyeo11]

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

[MK_QSL]

If(sum(STK_CLOSE) > 0 and sum(STK_OPEN) > 0, IF(Mod(RowNo(),12)=0,360,30))

[sunny_talwar · Accepted solution]

Or this:

If(sum(STK_CLOSE) > 0 and sum(STK_OPEN) > 0, Max(Month(YearMonth))*30)

[paulyeo11]

Hi Sunny

it work many thank.

Paul