Forum Discussion

Manasa's avatar
Manasa
New Contributor III
2 years ago

Reading current month in XFBR

Hello, I have a requirement where I'll have to read the current month in XFBR rule and return a string based on a few conditions. The time filter in the columns is set to |WFYear|.Base. I've tried ...
XFBR
Manasa's avatar
Manasa
New Contributor III

Hi Jon - I tried using the MF variables, but the problem is that I am returning the memberfilter from the paramhelper and not the name of the rows/columns and MFTime is giving an error when used as shown below.

is there a way to read the ColHeaderDisplayText in the rule or another way to read the current month? 

Thank you,

Manasa

ChristianW's avatar
ChristianW
Valued Contributor
2 years ago

Hi Manasa

Instead of using the xfbr to just return the ud8 selection for a list, you can use the xfbr function to create a comma separated list of povs.

Instead of UD8#xfbr(ParamaHelper, GetMemberFilter, |MfTime|)

do

xfbr(ParamaHelper, GetMemberFilter, time=T#|WfYear|.base) to create

T#2023M1:UD8#MemberForM1, T#2023M2:UD8#MemberForM2, …, T#2023M12:UD8#MemberForM12,