How to return the month/time period of other line itme

Hello, I have a module with two line items. This module has product list on pages and line items on rows. 'Max Slots' has a formula that returns the MAX value of a given product from another module. For the other line item 'when' I am trying to return the month or time period that the MAX value takes place. I am trying MONTHVALUE but I can not get it to work. Any suggestions? 

Answers

  • @davargas 

     

    Pictures would be very helpful here, and I am not sure you needed to start a new thread.

  • davargas_0-1659458191661.png

    I just want 'when' to return the month that 'Max Slots' took its value from. %Width Factor is a user input. 'Width' should return the months where the slot values are > %width factor of Max Slots.