by admin_mdo | Jul 29, 2018 | Calculations, LEARN App Building

** 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

by admin_mdo | Jun 18, 2016 | Calculations, DemoScreenShots

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