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

davargas
davargas
in Integrations and extensibility

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? 

Tagged:

Answers

  • rob_marshall
    rob_marshall

    @davargas 

     

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

  • davargas
    davargas

    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. 

Categories