New Contributor

Data Split

I have data of products sales in years (FY17, FY18, FY19 & FY20), how can i allocate it to monthly for a given financial year?

2 REPLIES 2
Highlighted
Super Contributor

Re: Data Split

Hi,

 

The keyword you're looking for is YEARVALUE.

I've attached a simple example of dividing yearly value by 12 below.

 

Screen Shot 2019-06-22 at 1.02.14 PM.png

 

Thanks,

LipChean

New Contributor

Re: Data Split

Thanks LopChean.