Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

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