Forum Discussion
Time intelligence related issue
Hello Community, Greetings! I am running into some serious issue, I have a data set which has columns shipstart, shipend and profit amount, 1) Based on this data set I wnat to calculate if...
Anonymous Maybe:
Column = VAR __ShipStart = [Ship start] VAR __ShipEndDate = [Ship end] VAR __Offer = [Approved offers $] VAR __TotalMonths = DATEDIFF( __ShipStart, __ShipEnd, MONTH ) + 1 VAR __TotsMonths = DATEDIFF( __ShipStart, DATE( 2023, 7, 31 ) + 1 VAR __Result = DIVIDE( __Offer, __TotalMonths ) * __TotsMonths RETURN __Result
Thanks realy appreciate your help Greg_Deckler