Using Dynamic Reference in SELECT Minus Statement

Hi,

You can do this calculation (Day - Project Length) in a metric and use it in the select

Hi ​@Nathan Can you explain or provide an example of how I would do this calculation in another metric? Day is a dimension so I dont see how I could do this calculation outside of a select

​@LAS Can you modify your formula as below and see if it works?

if(Day.First_Workday, Day[Day.’Day of  Week’.Working_Days][Add: Project][select: Day - Project_Length]

[Add: Project]  is used to add dimension of Project to your metric

​@Min Li Bright Point Thanks for this but unfortunately the Select can only subtract using a metric if the metric the formula is written is one dimensional

you can do the metric by Day and Project, do Day - Project Length and select on that.

You can also do SHIFT() within your select but I try to avoid putting functions within modifiers

​@LAS I tried the method that ​@Nathan suggested and it worked. You can adjust your formula as shown below.

'16. Metric 2'[by constant: shift(Day,-'16. Project Length')]

'16. Metric 2' is your source metric dimensioned by day and project.