Static value tied with weekly time and assingee

Questions & Answers
4

Hi,

You can expand further the formula with nested CASE statements like this:

CASE WHEN
 DateBetween([Time.Weekly].CurrentHierarchyMember.StartDate,
  DateParse('May 31 2021'),DateParse('Jun 06 2021')
 )
 THEN 
CASE [Logged by].CurrentMember.Name
WHEN “Employee1” THEN 0
WHEN “Employee2” THEN 35
WHEN “Employee3” THEN 40
END
--next branches follow here

 ELSE 40
 END

It is, however, recommended that you check more automated solutions. If you have the employee rate list available in a spreadsheet or any other format available for additional data import you may follow this example:

Kindly,
Janis, eazyBI support

1 Like