Skip to main content
Month Seat Worker Future_Worker Future_Worker_Current_Seat
Month Dimension Seat Dimension Worker Dimension Worker Dimension Seat Dimension

Mar 25

 POS-000100 Employee 1    
Mar 25 POS-000200 Open Position Employee 1 ???

 

Looking for some help writing a formula. I have a transaction list called EE_Load_HRIS. I’m looking to write a formula that will return the Seat (POS-000100) in the Future_Worker_Current_Seat property where the Month matches Month and the Worker matches Future_Worker.

See if this formula works:

EE_Load_HRIS.Seat[BY LASTNONBLANK: EE_Load_HRIS.Month, EE_Load_HRIS.Worker]
// This first line, if pasted in formula playground, creates a Metric showing the Seat of each Worker by Month
/BY: EE_Load_HRIS.Month, EE_Load_HRIS.Future_Worker]
// This next line takes the results of the first line and maps it back to the Transaction list

 

​@gablahoz Excellent - this worked great. Thank you very much!

Reply


Ask your question here!

Terms & ConditionsCookie settings