Get the Sum of Column

AtzdGr8

Hi everyone. how can i get the sum of Lease Liability column in Module 1 and insert to Monthly column in Module 2

Module 1:

Module 2:

jagadishdash

@AtzDGreat

In your 2nd module ensure which line item (date from or date to) can represent the months from the module 1 lase liability.

Create another line item to convert that particular date line items to month formatted as Dec 25 (12/31/25) and do the lookup in for the line item to bring the lase liability.

You can use Time sum to get the value also.

Hope it helps.

rob_marshall

@AtzDGreat

Use TimeSum()

https://help.anaplan.com/timesum-45c3bc48-4d80-490d-9b18-76af505c6907