Forum Discussion

BJankic's avatar
BJankic
Icon for Helper II rankHelper II
3 years ago
Solved

Calculate Contract Renewed Amount in Second Column

Hi,   I'm trying to calculate renewed amount in second column (renewed value). This is original data information   account_id account_name service_contract name contract_stage service_cont...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    BJankic Try something like:

    Column = 
  VAR __AccountID = [account_id]
  VAR __Start = [service_contract_start]
  VAR __Next = MINX(FILTER(ALL('Table'),[account_id] = __AccountID && [service_contract_start] > __Start),[service_contract_start])
  VAR __Value = MINX(FILTER(ALL('Table'), [account_id] = __AccountID && [service_contract_start] = __Next), [service_contract_value]
RETURN
  __Value