KirillKuznetsov 
Plan with Anaplan
-
Re: What are these fiunctions for?: HALFYEARVALUE, QUARTERVALUE, WEEKVALUE, YEARVALUE
Hi @KOBAYASHI Very good question. Let me use a bit simplier example, maybe this will clarify it to you. Let's say you have a simple year filter module managed by user. (User selected FY21) FY21F…1 -
Re: What are these fiunctions for?: HALFYEARVALUE, QUARTERVALUE, WEEKVALUE, YEARVALUE
Your example is the same. You are comparing whatever lays in Jan 21 (or month value of the Net Profit) vs each respective week (or Net Profit).1 -
Re: What are these fiunctions for?: HALFYEARVALUE, QUARTERVALUE, WEEKVALUE, YEARVALUE
@KOBAYASHI Another thing to add is that each of the functions are referencing the upper level and have to be used in the lower levels of time schale: YEARVALUE - Days, Weeks, Months, Quarters, Half-Y…1 -
Re: What are these fiunctions for?: HALFYEARVALUE, QUARTERVALUE, WEEKVALUE, YEARVALUE
@KOBAYASHI One example for you. Summary method is Closing Balance: Jan 21Feb 21Mar 21Q1(Closing Balance) A=QUARTERVALUE(B)333 B1233 Quarter Time PeriodQ1Q1Q1 C=B[LOOKUP:Quarter Time Period]3331 -
Re: select
@saurabh_kumar_kunwar SELECT is a very useful where you want to get data from a specific list element and this list is a structural data (not production data). Let's say you have 5 plants as you…1
