Monthly Expression in Straight Table

[sona_sa]

Hi Team,

Please find the attached QVW and excel.

Any Luck to make an expression for the same.

Thanks

[basav]

Please explain more about your requirements. Thanks. 

[dineshm030]

Please Find the QVW.

[sona_sa]

Hi Dinesh,

Output is correct, Can u build the same in my QVW. Backyear month will follow the same.

Please find the attached QVW.

Thanks

[sona_sa]

Hi Basavraju, Below is required information :

Hi

I have to make an expression for Count in my Straight Table.

For April - (4729 + May Month DOL -May Month DOJ) = 4758

For May - (4718 + June Month DOL -June Month DOJ) = 4729

For June – 4718 = Count({<DOL1={'01/01/1900', ">=$(=Today())"}>} DISTINCT EmpCode)

Please find the attached QVW for ref.

Thanks.

[NitinK7]

Hi

find the attached QVW, may be it will work to you.

[sona_sa]

Hi Nitin,

You got my point, But You have to Pick June Month HC = 4718 and It will go back ward.

Please find correct output. It will help you to make an expression.

Regards,

Sona_Sa