Expression for create each row 30 count total 12 row 360 count ?

[paulyeo11]

Hi Sir

Now i manually create a field in my row data DAY30 , which is not what i like :-

Row 1  30

Row 2    60

Row 3    90

Row 12  360

Then i use Sum(DAY30)to give the value i want.

May i know how to create this column using expression ? which give each row 30 for 12 row , total 12 row = 360.

meaning how to do it using expression , instead of manually enter at raw data ?

Paul

[sunny_talwar · Accepted solution]

Try this expression:

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

[paulyeo11]

Hi Sunny

Many thank it work great.

Paul

[paulyeo11]

Hi Sunny

Now i have another question :-

How to make my Table 2 Display RATIO = 0.354 , Now it display 1.297