Data Split

mayaaz

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

LipChean_Soh

Hi,

 

The keyword you're looking for is YEARVALUE.

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

 

 

Thanks,

LipChean

mayaaz

Thanks LopChean.