Rate Table You can use columns in the Rate Table dimension to add information about the Rate Table used to calculate commission data. Screen Rate Table Columns Columns The following […]

Credit Type You can use columns in the Credit Type dimension to add information about the Credit Type for credit data. Screen Credit Type Columns Columns The following table describes […]

Rule You can use columns in the Rule dimension to add information about the rule used to calculate orders, credits, commissions, and bonus data. Screen Rule Columns Columns The following […]

Position You can use columns in the Position dimension to add information about the Positions to orders, credits, commissions, bonuses, draws, quotas and payments data. Positions can also be used [&he...

Plan You can use columns in the Plan dimension to add information about the Plan to credits, commissions, and bonus data. Screen Plan Columns Columns The following table describes the […]

Release Period You can use columns in the Release Period dimension to segment information by release period for credits, commissions, and bonuses. The period type (for example, quarter or year) [&hell...

Period You can use columns in the Period dimension to segment information by period for orders, credits, commissions, bonuses, draws, quotas, and payments data. The period type (for example, quarter [...

Customer Use columns in the Customer dimension to add information about customers to orders, credits, commissions, bonuses, and payments data. Note that the Customer dimension includes columns Level 1...

Math Functions The math functions perform mathematical operations. Functions ABS This function calculates the absolute value of a numeric expression. Syntax ABS(numExpr) Where numExpr is any expressio...

Aggregate Functions Aggregate functions perform operations on multiple values to create summary results. Functions AGGREGATE AT This function aggregates columns based on the level or levels you specif...