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

davargas
New Contributor

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? 

2 REPLIES 2
rob_marshall
Moderator

@davargas 

 

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

davargas
New Contributor

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.