SELECT/LOOKUP formula

Hello,

I need to write a formula to taka data from one module, but only for current month.

I can not use LOOKUP function, because dimension doesn't match.

e.g. When the formula includes selecting a specific month by SELECT: Month.October everything works, but I want to give the user the option to select the current month.

Can you advise something?

Thank you!

Accepted answers

All comments

Thijso

Hi Dominika,
I think you should create a line item "Current Period" where the formula is PERIOD(CURRENTPERIODSTART()) and the formatting is set to "Period - Month" => This will give you the current month

Create a second line item with the select function where you use your first line item as an argument : X [SELECT: TIME.'Current Period']

Hope this helps.

Grts,

kevin.cho

If you're using a bare SELECT on a single time period, then a LOOKUP should work fine as well - as long as the line item you're using to do the LOOKUP on is dimensioned appropriately.

If the time period you want to retrieve is a constant (across all other dimensions), then create a line item formatted as "Time Period" (Month) with no dimensionality applied (clear the "Applies To", turn off Time and Versions).

You can then write your formula as = Source Line Item[LOOKUP: Time Period]

where "Source Line Item" is your source line item dimensioned against Time, and Time Period is the newly created line item with no dimensions applied

rob_marshall

@Dominika_Dudzinska

@kevin.cho is absolutely correct. In addition, you should only use SELECT statements on structured data (top members of lists, Native Versions, and keywords for Time (All Time Periods)

Rob

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…