Skip to Content
avatar image
Former Member

req logic for pick value for latest month only

hi all,

   i need logic for below attached image ,please advice

Thanks in Advance.

Ashwin

p1.png (15.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 26, 2014 at 05:44 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 26, 2014 at 06:28 AM

    Hi,

    You can use following formula:

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

    Regards

    Sheetal

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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