Formula for Business Objects custom variable in OBI
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!