Skip to Content

Formula Block Filter

Hi Experts,

I need some urgent help on below table. I am trying to extract only Maximum calendar day for each department in an formula variable to apply on the attached table restriction could you kindly help with an formula:

What i tried so far below without success:

=If (Max([Calendar day]) In ([name]) = [Calendar day]) Then 1 Else 0

tried even:

=If (Max([Calendar day]) In ([name];dept) = [Calendar day]) Then 1 Else 0

Appreciate on your quick help

Thanks,

Dinya

capture.jpg (20.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 07 at 06:38 AM

    first check data should be date of Calendar day object.

    Try with this.

    =if(calendar day)=max(calendar day) in ( name) then 1 else 0

    Add comment
    10|10000 characters needed characters exceeded