Boolean value from a Time Dimensioned to non-time dimensioned module

yatin.ajbani
yatin.ajbani
in Integrations and extensibility

Hi Team

I want to pull a Boolean value from a time dimensioned module to a non time dimensioned module. Source module looks something like 

yatinajbani_0-1665431560856.png

 

 

Could you please suggest?

Thanks

Tagged:

Best Answers

  • ChrisAHeathcote
    ChrisAHeathcote
    Answer ✓

    Use LOOKUP function using the current period as the reference. 

  • yatin.ajbani
    yatin.ajbani
    Answer ✓

    Thanks, Chris. Earlier I was applying lookup to a time period where it was a boolean value. Once I changed it to time format, it worked. Appreciate quick response. 

Categories