Formula for Business Objects custom variable in OBI

Content

I am currently recreating several reports in OBI with custom variables from Business Objects such as the one below and I am having trouble creating the formula in OBI. We have multiple custom variables that indicate the date of when a candidate was moved to a specific status and then we do a days between between calculation between those custom variables. In the report there is typically one date from at least one status in each step of our CSW. 

=Max(([Application Historical CSW Start Date]) In ([Application ID]) Where([Application Historical CSW Status]="Intake OffAcc"))

Any ideas/help would be greatly appreciated. Thanks!