MyDataOrganizer Sales Summary Rollup Function Formula

MyDataOrganizer Sales Summary Rollup Function Formula

 CustomerSales Data :

 

 

Table Admin Utilities provide options for creation of functions based upon table-fields-columns.

Rollup Summary function ccf50328 is created from it.

 

 

 

Calculated Field Formula is added to the table SalesYear_A31.

 

 

 

Result of use of Summary Rollup Function Formula is shown in SalesYear data.

For each Sales Year sum of Sales is calculated from CustomersSales_A31 and is shown in SalesYear_A31 table.

Similarly in each place where SalesYear field is present , we can use the same technique to get SumSalesRollup

to show sum of sales for the specific year.

 

 

 

For Any Question please Contact MyDataOrganizer

Calculation Formulas of Quarter Dates

Calculation of Quarter Dates

Starting date of Quarter depends upon Starting date of year.

When Year starts on Jan 1 then Q1 will start on Jan 1.

When Year starts on Jan 1 then Q4 will start on Oct 1 in the same year.

Quarter Dates when year starts on Jan 1 is shown above.

Calculation Formulas for Quarter Dates when year starts on Jan 1 is shown below:

When Year starts on Oct 1 then Q1 will start on Oct 1.

When Year starts on Oct 1 then Q4 will start on Jul 1 in the next year..

Quarter Dates when Year starts on Oct 1 is shown below.

Calculation Formulas for Quarter Dates when year starts on Oct 1 is shown below:

To view the following formulas in normal size Click the following image

For Any Question please Contact MyDataOrganizer