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