Calculation Rows
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
]]>
Table Column Headings
]]>
if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts.Count=0 or reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts.Count=0) then 'PARTNER 1'
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts.Count!=0 or reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts.Count!=0) and
(reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue=false and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue=false)
then 'PARTNER 1'
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts.Count!=0) and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue
then
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts[0].Code+"]|Partner|Value|New/EditPartners|General|Titles|Current Period")[0].Value
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts.Count!=0) and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue
then reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts[0].Code+"]|Partner|Value|New/EditPartners|General|Titles|Current Period")[0].Value
else 'PARTNER 1'
if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts.Count=0 or reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts.Count=0) then 'PARTNER 1'
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts.Count!=0 or reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts.Count!=0) and
(reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue=false and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue=false)
then 'PARTNER 1'
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts.Count!=0) and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue
then
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts[0].Code+"]|Partner|Value|New/EditPartners|General|Initials|Current Period")[0].Value
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts.Count!=0) and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue
then reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts[0].Code+"]|Partner|Value|New/EditPartners|General|Initials|Current Period")[0].Value
else 'PARTNER 1'
and
if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 2 3').Accounts.Count=0 or reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 2 3').Accounts.Count=0) then 'PARTNER 1'
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 2 3').Accounts.Count!=0 or reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 2 3').Accounts.Count!=0) and
(reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 2 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue=false and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 2 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue=false)
then 'PARTNER 1'
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 2 3').Accounts.Count!=0) and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 2 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue
then
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 2 3').Accounts[0].Code+"]|Partner|Value|New/EditPartners|General|Titles|Current Period")[0].Value
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 2 3').Accounts.Count!=0) and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 2 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue
then reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 2 3').Accounts[0].Code+"]|Partner|Value|New/EditPartners|General|Titles|Current Period")[0].Value
else 'PARTNER 1'
if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 2 3').Accounts.Count=0 or reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 2 3').Accounts.Count=0) then 'PARTNER 1'
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 2 3').Accounts.Count!=0 or reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 2 3').Accounts.Count!=0) and
(reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 2 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue=false and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 2 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue=false)
then 'PARTNER 1'
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 2 3').Accounts.Count!=0) and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 2 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue
then
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 2 3').Accounts[0].Code+"]|Partner|Value|New/EditPartners|General|Initials|Current Period")[0].Value
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 2 3').Accounts.Count!=0) and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 2 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue
then reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 2 3').Accounts[0].Code+"]|Partner|Value|New/EditPartners|General|Initials|Current Period")[0].Value
else 'PARTNER 1'
if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts.Count=0 or reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts.Count=0) then 'PARTNER 1'
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts.Count!=0 or reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts.Count!=0) and
(reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue=false and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue=false)
then 'PARTNER 1'
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts.Count!=0) and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue
then
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Accounts[0].Code+"]|Partner|Value|New/EditPartners|General|Surname|Current Period")[0].Value
else if
(reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts.Count!=0) and
reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts[0].Code+"]|Partner|Value")[0].HasValue
then reporting.queries.client.lookupaccountingperioddata("Import/AccountAssignment|ProfitAllocation|ProfitAllocation|ProfitAllocation|ProfitAllocation|Rows|*:filter[Account|Value="+reportHelper.Computation(0.01m).Chart.GetNominalCategory('B25 1 3').Accounts[0].Code+"]|Partner|Value|New/EditPartners|General|Surname|Current Period")[0].Value
else 'PARTNER 1'
report.CurrencySymbol
ScalingHeader
]]>
Partner3Name
report.CurrencySymbol
ScalingHeader
]]>
Partner4Name
report.CurrencySymbol
ScalingHeader
]]>
Partner5Name
report.CurrencySymbol
ScalingHeader
]]>
Partner6Name
report.CurrencySymbol
ScalingHeader
]]>
Partner7Name
report.CurrencySymbol
ScalingHeader
]]>
Partner8Name
report.CurrencySymbol
ScalingHeader
]]>
Partner9Name
report.CurrencySymbol
ScalingHeader
]]>
Partner10Name
report.CurrencySymbol
ScalingHeader
]]>
Partner11Name
report.CurrencySymbol
ScalingHeader
]]>
Partner12Name
report.CurrencySymbol
ScalingHeader
]]>
Partner13Name
report.CurrencySymbol
ScalingHeader
]]>
Partner14Name
report.CurrencySymbol
ScalingHeader
]]>
Partner15Name
report.CurrencySymbol
ScalingHeader
]]>
Partner16Name
report.CurrencySymbol
ScalingHeader
]]>
Partner17Name
report.CurrencySymbol
ScalingHeader
]]>
Partner18Name
report.CurrencySymbol
ScalingHeader
]]>
Partner19Name
report.CurrencySymbol
ScalingHeader
]]>
Partner20Name
report.CurrencySymbol
ScalingHeader
]]>
Total
report.CurrencySymbol
ScalingHeader
]]>
Grand Total Values
reporting.queries.client.lookupaccountingperioddata("Disclosure|Presentation|Presentation|Presentation|Rounding|Current Period")[0].Value
reporting.queries.client.lookupaccountingperioddata("Disclosure|Presentation|Presentation|Presentation|Scaling|Current Period")[0].Value
Continuous Section Values
Final Section Values
Non-Continuous Section Values
Section Breakdown Rows
Description Column Heading
Section Heading Rows
]]>
CapitalAccountBreakdown
At reportHelper.CurrentPeriod.StartDate.Value.ToString('d MMMM yyy')
]]>
reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 2').Description]]>
reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 3').Description]]>
reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 4').Description]]>
reportHelper.Computation(0.01m).Chart.GetNominalCategory('B20 1 5').Description]]>
At reportHelper.CurrentPeriod.EndDate.Value.ToString('d MMMM yyy')
]]>
ClickHere
<< double-click to launch smart-table designer >>
]]>
Continuous Total Values
Final Section Total Values
Description Column Heading
Non-Continuous Section Total Values
Section Total Rows
Continuous Total Values
Final Total Values
Description Column Heading
Non-Continuous Total Values
Total Rows