BO formular to OBI
Summary
Me trying to breakdown a BO code...Content
Round( (Truncate(DaysBetween([Min Post Date - All Reqs];CurrentDate()) / 7 ; 0) * 5)
+ ToNumber(Substr("1234555123444512333451222345111234500123450123455"; ((DayNumberOfWeek([Min Post Date - All Reqs])-1)*7)+Mod(DaysBetween([Min Post Date - All Reqs];CurrentDate());7)+1 ; 1))-1-ToNumber([All Reqs].[Req. Total Days On Hold]*0.7143);0)
OBI has Round, Truncate and I suppose daysbetween is timestampdiff so I got the first part interpreted to
ROUND(TRUNCATE(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition Dates"."First Sourced Date", NOW()),0)/7, 0)*5 which looks right. The remaining bit is what is left
+ ToNumber(Substr("1234555123444512333451222345111234500123450123455"; ((DayNumberOfWeek([Min Post Date - All Reqs])-1)*7)+Mod(DaysBetween([Min Post Date - All Reqs];CurrentDate());7)+1 ; 1))-1-ToNumber([All Reqs].[Req. Total Days On Hold]*0.7143);0)