$10010
Cash
SO
10010-1000
Cash in Bank Accounts - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$10015
Petty Cash
SO
10015-1000
Petty Cash - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$10020
Accounts Receivables
SO
10020-1000
Accounts Receivable - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$10025
Inventory
SO
10025-1000
Inventory - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$10027
Prepaid Expenses
SO
10027-1000
Accruals and Prepaid Expenses - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$10030
Other current Assets
SO
10030-1000
Other current Assets - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$10035
Land
SO
10035-1000
Land - Generic Movement
7
▾
Input Lines (7)
Deployed Accounts
Output accounts
Input accounts
$10036
Land - Acc. Depreciation
SO
10036-1000
Land - Acc. Depreciation-Generic Movement
7
▾
Input Lines (7)
Deployed Accounts
Output accounts
Input accounts
$10040
Buildings
SO
10040-1000
Buildings - Generic Movement
7
▾
Input Lines (7)
Deployed Accounts
Output accounts
Input accounts
$10041
Buildings - Acc. Depreciation
SO
10041-0025
Buildings - Acc. Depreciation-Additions
7
▾
Input Lines (7)
Deployed Accounts
Output accounts
Input accounts
$10045
Property & Equipment
SO
10045
Property & Equipment
7
▾
Input Lines (7)
Deployed Accounts
Output accounts
Input accounts
$10046
Property & Equipment - Acc. Depreciation
SO
10046
Property & Equipment - Acc. Depreciation
7
▾
Input Lines (7)
Deployed Accounts
Output accounts
Input accounts
$10050
Other Tangible Assets
SO
10050-1000
Other Tangible Assets - Generic Movement
7
▾
Input Lines (7)
Deployed Accounts
Output accounts
Input accounts
$10051
Other Tangible Assets - Acc. Depreciation
SO
10051-1000
Other Tangible Assets - Acc. Depreciation-Generic Movement
7
▾
Input Lines (7)
Deployed Accounts
Output accounts
Input accounts
$10055
Accumulated Depreciation
SO
10055-1000
Accumulated Depreciation - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$10060
Goodwill
SO
10060-1000
Goodwill - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$10065
Other Intangible Assets
SO
10065-1000
Other Intangible Assets - Generic Movement
7
▾
Input Lines (7)
Deployed Accounts
Output accounts
Input accounts
$10070
Accumulated Amortization
SO
10070-1000
Accumulated Amortization - Generic Movement
7
▾
Input Lines (7)
Deployed Accounts
Output accounts
Input accounts
$10075
Financial Investments In Consolidated Affiliates
SO
10075
Financial Investments In Consolidated Affiliates
5
▾
Input Lines (5)
Deployed Accounts
Output accounts
Input accounts
$10080
Financial Investments In Unconsolidated Affiliates
SO
10080
Financial Investments In Unconsolidated Affiliates
5
▾
Input Lines (5)
Deployed Accounts
Output accounts
Input accounts
$20010
Accounts Payables
SO
20010-1000
Accounts Payable - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$20015
Accrued Liabilities
SO
20015-1000
Accrued Liabilities - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$20020
Interest Paybales
SO
20020-1000
Interest Paybales - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$20025
Tax Payables
SO
20025-1000
Tax Payables - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$20030
S/T Credit lines
SO
20030-1000
S/T Debit lines - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$20035
Othe current liabilities
SO
20035-1000
Othe current liabilities - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$20040
Bonds Payables
SO
20040-1000
Bonds Payables - Generic Movement
3
▾
Input Lines (3)
Deployed Accounts
Output accounts
Input accounts
$20045
L/T Debt
SO
20045-1000
L/T Debt-Generic Movement
7
▾
Input Lines (7)
Deployed Accounts
Output accounts
Input accounts
$30010
Common Stock
SO
30010
Common Stock
6
▾
Input Lines (6)
Deployed Accounts
Output accounts
Input accounts
$30015
Reserves
SO
30015
Reserves
6
▾
Input Lines (6)
Deployed Accounts
Output accounts
Input accounts
$30020
Cumulative Trals. Adjustment
SO
30020
Cumulative Trals. Adjustment
6
▾
Input Lines (6)
Deployed Accounts
Output accounts
Input accounts
$30025
Retained Earnings
SO
30025
Retained Earnings
8
▾
Input Lines (8)
Deployed Accounts
Output accounts
Input accounts
$30027
Non Controlling Interest
SO
30027
Non Controlling Interest
6
▾
Input Lines (6)
Deployed Accounts
Output accounts
Input accounts
$30028
Additional Paid in Capital
SO
30028
Additional Paid in Capital
6
▾
Input Lines (6)
Deployed Accounts
Output accounts
Input accounts
$30029
Equity pick-up BS
SO
30029
Equity pick-up BS
6
▾
Input Lines (6)
Deployed Accounts
Output accounts
Input accounts
$30030NCI
NCI: Current Year Result
SO
30030NCI
NCI: Current Year Result
6
▾
Input Lines (6)
Deployed Accounts
Output accounts
Input accounts
$30031
Treasury Stock
SO
30031
Treasury Stock
6
▾
Input Lines (6)
Deployed Accounts
Output accounts
Input accounts
$AUM
AUM Ending Balance
SO
ST_1550_END
Asset Under Management - Ending Balance
4
▾
Input Lines (4)
Deployed Accounts
Output accounts
Input accounts
$BS_RESULT_01
$BS_RESULT_01
SO
30030
Current Year Result
1
▾
Input Lines (1)
Deployed Accounts
Output accounts
Input accounts
$BS_RESULT_FLOW_01
$BS_RESULT_FLOW_01
SO
30030-0160
Current Year Result - Fiscal year's result
1
▾
Input Lines (1)
Deployed Accounts
Output accounts
Input accounts
$PL_RESULT_01
$PL_RESULT_01
SO
99999
P&l Net Income
1
▾
Input Lines (1)
Deployed Accounts
Output accounts
Input accounts
AUM_COMMISSION
Asset Under Management - Revenues from Commission
MD
—
—
▾
TGKML Formula
Deployed Accounts
Dependencies
Output
Input Accounts
ST_1470
ST_1550_END
ST_1480
TGKML Script
TGKML 1.0
[LO].[ST_1470](Pro) := [ST_1550_END]*[ST_1480](Time.Scenario.Last);
Output accounts
Input accounts
AUM_REV
Asset Under Management - Revenues from Fees
MD
—
—
▾
TGKML Formula
Deployed Accounts
Dependencies
Output
Input Accounts
macro
@DAYS
ST_604
ST_1500
ST_1550_END
ST_1490
TGKML Script
TGKML 1.0
[LO].@DAYS := [ST_604](Per,Time.Scenario.[2019BDG],Dest1.[CC_500],Dest2.[PD_500],Dest3.[CM_500],Dest4.[EE_500],Dest5.[NA],Entity.[EN_00],Currency.[USD],Category.[010])/[ST_604](Time.Scenario.[2019BDG].Last,Dest1.[CC_500],Dest2.[PD_500],Dest3.[CM_500],Dest4.[EE_500],Dest5.[NA],Entity.[EN_00],Currency.[USD],Category.[010]);
[LO].[ST_1500](Pro) := [ST_1550_END]*[ST_1490](Time.Scenario.Last)*@DAYS/10000;
Output accounts
Input accounts
HR_050
Salary and Wages
MD
—
—
▾
TGKML Formula
Deployed Accounts
Dependencies
Output
Input Accounts
macro
@pay_periods
ST_602
macro
@pay_periods_per
ST_602
macro
@working_hrs_per_year
ST_610
macro
@salary_plan_rate
ST_612
macro
@workersompPerHeadMonthly
ST_614
macro
@monthlyMaintEstimate
PYL_300
macro
@dental_ind_basic
ST_656
macro
@dental_ind_preium
ST_658
macro
@dental_fam_basic
ST_660
macro
@dental_fam_premium
ST_662
macro
@medical_ind_basic
ST_648
macro
@medical_ind_preium
ST_650
macro
@medical_fam_basic
ST_652
macro
@medical_fam_premium
ST_654
macro
@retirement_1
ST_664
macro
@retirement_2
ST_666
macro
@retirement_3
ST_668
macro
@retirement_4
ST_670
macro
@ficaRate
ST_618
macro
@ficaLimit
ST_620
macro
@medicare
ST_616
macro
@futaRate
ST_626
macro
@futaLimit
ST_628
macro
@sutaRate
ST_622
macro
@sutaLimit
ST_624
macro
@budget_salary
ST_495
macro
@dental
ST_685
macro
@medical
ST_680
macro
@retirement
ST_675
macro
@effective_date
ST_457
macro
@bonus
ST_500
macro
@bonus_payout
ST_606
macro
@positionEeFTE
macro
@number_of_position
ST_1170
macro
@status
ST_450
ST_540
60010
macro
@eeSalaryPer
60010
macro
@eeSalaryProFederal
60010
macro
@eeSalaryProState
60010
60020
60055
60050
60060
macro
@otherBenefitsPerHeadMULMedicare
macro
@eeSalaryProSUBficaLimit
macro
@fica
60030
macro
@futa
60035
macro
@suta
60040
TGKML Script
TGKML 1.0
// Tagetik North America LLC// MD Rules//// Changelog: // ****** Global Environemnt Configuration - Dimensions ****** //Department : {Dest1};
Products : {Dest2};
Customers : {Dest3};
Employee : {Dest4};
Miscellaneous : {Dest5};
Ctg : {Category.[010]};
Term : {Category.[125]};
UnpaidLeave : {Category.[124]};
// ****** Global Variable and Filters declaration ****** //GA : {@Department.
[CC_500],@Products.[PD_500],@Customers.[CM_500],@Employee.[EE_500],@Miscellaneous.[NA],Entity.[EN_95],@Ctg};
TSL : {Time.Scenario.Last};
// Global Assumptions
[LO].@pay_periods := [ST_602](@GA,@TSL);
[LO].@pay_periods_per := [ST_602](Per,@GA);
//
[LO].@working_hrs_per_year := [ST_610](@GA,@TSL);
//
[LO].@salary_plan_rate := [ST_612](@GA,@TSL);
//
[LO].@workersompPerHeadMonthly := [ST_614](@GA,@TSL);
//
[LO].@monthlyMaintEstimate := [PYL_300](@GA,@TSL);
[LO].@dental_ind_basic := [ST_656](@GA,@TSL);
[LO].@dental_ind_preium := [ST_658](@GA,@TSL);
[LO].@dental_fam_basic := [ST_660](@GA,@TSL);
[LO].@dental_fam_premium := [ST_662](@GA,@TSL);
[LO].@medical_ind_basic := [ST_648](@GA,@TSL);
[LO].@medical_ind_preium := [ST_650](@GA,@TSL);
[LO].@medical_fam_basic := [ST_652](@GA,@TSL);
[LO].@medical_fam_premium := [ST_654](@GA,@TSL);
[LO].@retirement_1 := [ST_664](@GA,@TSL);
[LO].@retirement_2 := [ST_666](@GA,@TSL);
[LO].@retirement_3 := [ST_668](@GA,@TSL);
[LO].@retirement_4 := [ST_670](@GA,@TSL);
[LO].@ficaRate := [ST_618](@GA,@TSL);
[LO].@ficaLimit := [ST_620](@GA,@TSL);
[LO].@medicare := [ST_616](@GA,@TSL);
[LO].@futaRate := [ST_626](@GA,@TSL);
[LO].@futaLimit := [ST_628](@GA,@TSL);
[LO].@sutaRate := [ST_622](@GA,@TSL);
[LO].@sutaLimit := [ST_624](@GA,@TSL);
// Miscellaneous
[LO].@budget_salary := [ST_495](@TSL);
[LO].@dental := [ST_685](@TSL);
// P&L 60055, dental_ind_basic = 1, dental_ind_preium = 2, dental_fam_basic = 3, dental_fam_premium = 4
[LO].@medical := [ST_680](@TSL);
// P&L 60050, medical_ind_basic = 1, medical_ind_preium = 2, medical_fam_basic = 3, medical_fam_premium = 4
[LO].@retirement := [ST_675](@TSL);
// P&L 60060, plan_1 = 1, plan_2 = 2, plan_3 = 3, plan_4 = 4
[LO].@effective_date := [ST_457](@TSL);
[LO].@bonus := [ST_500](@TSL);
[LO].@bonus_payout := [ST_606](@GA,@TSL);
// P&L 7050 annual (3) dec, semi-ann (2) june and dec, quart. (1) march, june, sept, dec
[LO].@eeFTE := if PeriodIndex < @effective_date then 1 else 0 end;
[LO].@positionEeFTE := if PeriodIndex >= @effective_date then 1 else 0 end;
[LO].@number_of_position := [ST_1170](@TSL);
[LO].@status := [ST_450](@TSL);
[LO].[ST_540](@Ctg,@Employee.Filter([100|110])) := @eeFTE;
[LO].[ST_540](@Ctg,@Employee.Filter([100|130])) := @positionEeFTE * @number_of_position;
[LO].[ST_540](@Term,@Employee.Filter([100|110])) := if PeriodIndex >= @effective_date and @status == 4 then 1 else 0 end;
[LO].[ST_540](@UnpaidLeave,@Employee.Filter([100|110])) := if PeriodIndex >= @effective_date and @status == 2 then 1 else 0 end;
// ******* Wages & Salaries ******* //
[LO].[60010](Pro,@Employee.Filter([100|110])) := if PeriodIndex < @effective_datethen @budget_salary / (@effective_date - 1)else 0end;
[LO].[60010](Pro,@Employee.Filter([100|130])) := if PeriodIndex >= @effective_datethen @budget_salary / (12 - @effective_date + 1) else 0end;
// Needed by Taxes
[LO].@eeSalaryPer := [60010](Per);
//
[LO].@eeSalaryProFederal := [60010];
//
[LO].@eeSalaryProState := [60010];
//
[LO].@eeSalaryProFederal := [60010](Category.Filter([010],[180]),Entity.All);
//
[LO].@eeSalaryProState := [60010](Category.Filter([010],[180]),Entity.All);
// ******* Benefits ******* //// Bonus
[LO].[60020](Pro,@Employee.Filter([100|110])) := @eeFTE * @bonus / (if @bonus_payout == 1 then (if PeriodIndex == 3 or PeriodIndex == 6 or PeriodIndex == 9 or PeriodIndex == 12 then 4 else 0 end) else if @bonus_payout == 2 then (if PeriodIndex == 6 or PeriodIndex == 12 then 2 else 0 end) else if @bonus_payout == 3 then (if PeriodIndex == 12 then 1 else 0 end) end end end );
[LO].[60020](Pro,@Employee.Filter([100|130])) := @positionEeFTE * @bonus / (if @bonus_payout == 1 then (if PeriodIndex == 3 or PeriodIndex == 6 or PeriodIndex == 9 or PeriodIndex == 12 then 4 else 0 end) else if @bonus_payout == 2 then (if PeriodIndex == 6 or PeriodIndex == 12 then 2 else 0 end) else if @bonus_payout == 3 then (if PeriodIndex == 12 then 1 else 0 end) end end end );
// Dental
[LO].[60055](Pro,@Employee.Filter([100|110])) := @eeFTE * (if @dental == 1 then @dental_ind_basic else if @dental == 2 then @dental_ind_preium else if @dental == 3 then @dental_fam_basic else if @dental == 4 then @dental_fam_premium end end end end);
[LO].[60055](Pro,@Employee.Filter([100|130])) := @positionEeFTE * @number_of_position * (if @dental == 1 then @dental_ind_basic else if @dental == 2 then @dental_ind_preium else if @dental == 3 then @dental_fam_basic else if @dental == 4 then @dental_fam_premium end end end end);
// Medical
[LO].[60050](Pro,@Employee.Filter([100|110])) := @eeFTE * (if @medical == 1 then @medical_ind_basic else if @medical == 2 then @medical_ind_preium else if @medical == 3 then @medical_fam_basic else if @medical == 4 then @medical_fam_premium end end end end);
[LO].[60050](Pro,@Employee.Filter([100|130])) := @positionEeFTE * @number_of_position * (if @medical == 1 then @medical_ind_basic else if @medical == 2 then @medical_ind_preium else if @medical == 3 then @medical_fam_basic else if @medical == 4 then @medical_fam_premium end end end end);
// Retirement
[LO].[60060](Pro,@Employee.Filter([100|110])) := @eeFTE * @eeSalaryPer * (if @retirement == 1 then @retirement_1 else if @retirement == 2 then @retirement_2 else if @retirement == 3 then @retirement_3 else if @retirement == 4 then @retirement_4 end end end end);
[LO].[60060](Pro,@Employee.Filter([100|130])) := @positionEeFTE * @eeSalaryPer * (if @retirement == 1 then @retirement_1 else if @retirement == 2 then @retirement_2 else if @retirement == 3 then @retirement_3 else if @retirement == 4 then @retirement_4 end end end end);
// ******* Taxes ******* ////
[LO].@eeSalaryPer := [60010](Per);
[LO].@eeSalaryProFederal := [60010](Category.Filter([010],[180]),Entity.All);
[LO].@eeSalaryProState := [60010](Category.Filter([010],[180]),Entity.All);
// FICA - Federal Insurance Contributions Act
[LO].@otherBenefitsPerHeadMULMedicare := @eeSalaryPer * @medicare;
[LO].@eeSalaryProSUBficaLimit := @eeSalaryProFederal - @ficaLimit;
[LO].@fica := if @eeSalaryProFederal < @ficaLimit then (@eeSalaryPer * @ficaRate) + @otherBenefitsPerHeadMULMedicareelse ( if @eeSalaryProSUBficaLimit <= @eeSalaryPer then @otherBenefitsPerHeadMULMedicare + ((@eeSalaryPer - @eeSalaryProSUBficaLimit) * @ficaRate) else @otherBenefitsPerHeadMULMedicare end)end;
[LO].[60030](Pro) := @fica;
// FUTA - Federal Unemployment Tax Act
[LO].@futa:= if @eeSalaryProFederal < @futaLimit then @eeSalaryPer * @futaRate else if (@eeSalaryProFederal - @futaLimit) <= @eeSalaryPer then (@eeSalaryPer - @eeSalaryProFederal + @futaLimit) * @futaRate end end;
[LO].[60035](Pro) := @futa;
// SUTA - State Unemployment Tax Authority
[LO].@suta:= if @eeSalaryProState < @sutaLimit then @eeSalaryPer * @sutaRate else if (@eeSalaryProState - @sutaLimit) <= @eeSalaryPer then (@eeSalaryPer - @eeSalaryProState + @sutaLimit) * @sutaRate end end;
[LO].[60040](Pro) := @suta;
Output accounts
Input accounts
MA_10
Calculate BOM
MD
—
—
▾
TGKML Formula
Deployed Accounts
Dependencies
Output
Input Accounts
ST_900
ST_900
macro
@UNIT
ST_900
macro
@PLATFORMUNITS
ST_900
020
ST_920
ST_917
ST_917
macro
@COSTPERPLATFORM
ST_917
55020
TGKML Script
TGKML 1.0
// Tagetik North America LLC// MD Rules//// Changelog: // ****** Global Environemnt Configuration - Dimensions ****** //Ctg : {Category.
[050]};
//CtgTD : {Category.
[055]};
CtgBOM : {Category.[060]};
GenCust:{Dest3.[CM_500]};
Product: {Dest2};
Platform: Parent([@Product]);
Location:{Entity.[EN_95]};
// ****** Global Variable and Filters declaration ****** //GA : {@Employees.
[EE_500],@CostCenters.[CC_500],@Miscellaneous.[NA]};
// Global Assumptions//NUMBER OF COMPONENTS SOLD//Copy Units to the Currency Note this can probably be built with less code so it can be automatic
[LO].[ST_900](@GA,@CtgBOM,@GenCust,Entity.[EN_00],Currency.[USD]):=[ST_900](@GA,@CtgBOM,@GenCust,@Location);
[LO].[ST_900](@GA,@CtgBOM,@GenCust,Entity.[EN_05],Currency.[USD]):=[ST_900](@GA,@CtgBOM,@GenCust,@Location);
[LO].[ST_900](@GA,@CtgBOM,@GenCust,Entity.[EN_10],Currency.[USD]):=[ST_900](@GA,@CtgBOM,@GenCust,@Location);
[LO].[ST_900](@GA,@CtgBOM,@GenCust,Entity.[EN_15],Currency.[CAD]):=[ST_900](@GA,@CtgBOM,@GenCust,@Location);
[LO].[ST_900](@GA,@CtgBOM,@GenCust,Entity.[EN_20],Currency.[CAD]):=[ST_900](@GA,@CtgBOM,@GenCust,@Location);
[LO].[ST_900](@GA,@CtgBOM,@GenCust,Entity.[EN_25],Currency.[EUR]):=[ST_900](@GA,@CtgBOM,@GenCust,@Location);
//
[LO].@UNIT:=[ST_900](@GA,@CtgBOM,@GenCust,@Location);
[LO].@UNIT:=[ST_900](@GA,@CtgBOM,@GenCust);
[LO].@PLATFORMUNITS:=[ST_900](@Product.RefLeaf(Parent([020])),@GA,@Ctg);
[LO].[ST_920](@CtgBOM):=@UNIT*@PLATFORMUNITS;
//COST OF GOODS SOLD//Copy Cost to appropriate Currency Note that this should be built with less code and should include Exchange Rate Calc
[LO].[ST_917](@GA,@CtgBOM,@GenCust,Entity.[EN_00],Currency.[USD]):=[ST_917](@GA,@CtgBOM,@GenCust,@Location);
[LO].[ST_917](@GA,@CtgBOM,@GenCust,Entity.[EN_05],Currency.[USD]):=[ST_917](@GA,@CtgBOM,@GenCust,@Location);
[LO].[ST_917](@GA,@CtgBOM,@GenCust,Entity.[EN_10],Currency.[USD]):=[ST_917](@GA,@CtgBOM,@GenCust,@Location);
[LO].[ST_917](@GA,@CtgBOM,@GenCust,Entity.[EN_15],Currency.[CAD]):=[ST_917](@GA,@CtgBOM,@GenCust,@Location);
[LO].[ST_917](@GA,@CtgBOM,@GenCust,Entity.[EN_20],Currency.[CAD]):=[ST_917](@GA,@CtgBOM,@GenCust,@Location);
[LO].[ST_917](@GA,@CtgBOM,@GenCust,Entity.[EN_25],Currency.[EUR]):=[ST_917](@GA,@CtgBOM,@GenCust,@Location);
[LO].@COSTPERPLATFORM:=[ST_917](@GA,@CtgBOM,@GenCust);
[LO].[55020](@Ctg):=@COSTPERPLATFORM*@PLATFORMUNITS;
//Unused formulas that worked previously, these are all Intended to be deleted eventually//
[LO].@COSTPERPLATFORM:=[ST_917](@GA,@CtgBOM,@GenCust,@Location);
//
[LO].[ST_900](@CtgBOM):=@UNIT*([ST_900](@Product.[SKU_11040],@GA,@CtgTD));
//
[LO].[ST_900](@Product.[SKU_11187],@GA,@CtgTD):=[ST_900](@Product.[SKU_11040],@GA,@CtgTD);
//
[LO].[ST_900](@Product.[SKU_11358],@GA,@CtgTD):=[ST_900](@Product.[SKU_11040],@GA,@CtgTD);
//
[LO].[ST_900](@CtgBOM):=@UNIT*([ST_900](@GA,@CtgTD));
Output accounts
Input accounts
RV_010
COGS Deduction
MD
—
—
▾
TGKML Formula
Deployed Accounts
Dependencies
Output
Input Accounts
macro
@Perc
ST_944
55020
50010
TGKML Script
TGKML 1.0
Cust : {Dest3.[CM_500]};
Cat : {Category.[010]};
Prod : {Dest2.RefLeaf(Ancestor([010|010], 3))};
[LO].@Perc := [ST_944](@Cat, @Cust,@Prod);
[LO].[55020](Pro,Category.Filter([010])):= - [50010](Per) * @Perc;
Output accounts
Input accounts
SP_10
Strat Plan Spreading
MD
—
—
▾
TGKML Formula
Deployed Accounts
TGKML Script
TGKML 1.0
[LO].Multi([50010]+[55010]+[90010],Pro,Category.Filter([100]),Category.[010]) := ([ ](Time.Scenario.Last,Entity.Parent([010]))*[ST_1250](Time.Scenario.Last,Dest5.[NA]) * [ST_1245](Per,Time.P3.Last,Entity.Parent([010]),Dest5.[NA]))/3;
Output accounts
Input accounts