Hi guys, I have a GI listed ending balance for current assets and current liabilities accounts by period. To create a dashboard KPI weights based on this GI, I need to create a filter for current month. Is there a way to define that “FinPeriodID = Current Period” ? Or is there a way to convert FinPeriodID to Month or Date? Because I know I can do a formula on filter for Month and Date, but not Period. :(
Solved
Create A Filter for Current Month
Best answer by RoyceLithgo
You just need a checkbox parameter for Current Month Only which you can set on the dashboard.
You then just need a condition to implement the Current Month Only parameter. Do you know how to do that?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.