Sum Data From start year in model

Highlighted
Occasional Contributor

Sum Data From start year in model

Hi, is there a way i can sum our balances from the start date i set in my time setting?

See attached screenshot. The balances should be for FY14 = FY13+FY14, for FY17 = FY13+FY14+FY15+FY16+FY17

tompatrickting_0-1596452233736.png

 

Thanks in advance for the help.

Tom

 

3 REPLIES 3
Highlighted
Super Contributor

Re: Sum Data From start year in model

Hi @tompatrickting,

 

Use Cumulate function

 

 

1.JPG

 

 

2.JPG

 

 

 

Thanks,

Sorna Raja Prabhu
Highlighted
Occasional Contributor

Re: Sum Data From start year in model

Thanks Sorna for assisting.

Highlighted
Super Contributor

Re: Sum Data From start year in model

Welcome 🙂
Sorna Raja Prabhu