ChrisAHeathcote 
-
Re: Actual to Forecast Line Chart Format
I was able to solve this particular challenge. Here is how I did it.... First task is to build a filter module where I run through the various IF THEN ELSE statements to create a grid which would all…1 -
Re: Overwrite calculated line items
@vd_ghnst How about creating a line item subset (LISS). Create a module using the LISS and and two line items for the calculation and override. Reference the two line items in the original module and…1 -
Re: Logic Line item availble two function (Input and Formula)
@adisulyadi It is not possible to combine a formula and a user defined input in the same line item. As described by @ArunManickam version scope is the only instance where this is possible where you c…1 -
Re: how to get the beginning month of the current year in a line item
@DMManalili Try using the following =PERIOD(START(Current Year Formatted Line Item)) The target line item should be month formatted. This will return the first month of the year being queried.1 -
Re: Allowing circular references
@MaartenGijbels Eliminate the circular reference by using the base data in all your calculations and avoid daisy chaining! Therefore, each time you need to reference a cup of coffee create a formula …1
