+3| 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.
Best answer by gablahoz
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.