Skip to main content

Hi Pigment team! Can you please help modifying this formula to be as following explanation?

 

Current formula:

IF(S03_IsActuals, 
'DH_Data_PL EBITDA Actuals'sFILTER: 'PL GLs'."60001"],
'TT_Base Salary USD'DREMOVE SUM: Country]yBY: 'PL GLs'."60001"]
)

I would like to add “EE_Salary_USD (Actual - Forecast)” metric in the “false” section, but with prior month result. I started like below, but I am not sure what to put in the highlighted section below: 

Example:

 

Thanks in advance!

Hi @Yaejis ,

In order to reference the prior month from another metric you can update your formula as follows:
 

IF(S03_IsActuals, 
'DH_Data_PL EBITDA Actuals'lFILTER: 'PL GLs'."60001"],
'TT_Base Salary USD'SREMOVE SUM: Country]rBY: 'PL GLs'."60001"] + EE_Salary_USD (Actual - Forecast)sSELECT: Month - 1]
)

Let me know if the problem is solved.

for more reading around the usage of this you can check the following article:
 


Best,
Issam


Reply