req logic for pick value for latest month only

[Former Member]

hi all,

   i need logic for below attached image ,please advice

Thanks in Advance.

Ashwin

[former_member211423]

Hi,

You can use following formula:

=[Completed] Where ([Cal.year/month]= (Max([Cal.year/month] ) In Block))

Regards

Sheetal

[Former Member]

Hi sheetal,

     can u elaborate the above formula bcoz i used prev

=[Completed] Where ([Cal.year/month]= (Max([Cal.year/month] ))

what is In Block here bcoz the formula now showing blank

Thanks..

Ashwin

[former_member211423]

Hi Ashwin,

In Block will take the maximum calender month in your report block/Table. You can use In report also if your report has only one block or the max value is same for all blocks.

If your report has more than on table/Block having different max calender date then max of all blocks will be considered if "In report" context is used.

Hope it helps

Regards

Sheetal

[Former Member]