How to "DataBand1 Then DataBand1Total" nested in GroupBandFooter?
In other words, how to complete "individuation total" ?
Detail:
GroupBandHeader_Master
DataBand_Master
GroupBandFooter_Master
{
DataBand_Detail_Addition (Relation: DataBand_Master.Column "EmpNo" equals this.Column "EmpNo" )
DataBand_Detail_Addition_Sum1 (i.e. Get Sum of DataBand_Detail_Addition that Column "type" is A)
DataBand_Detail_Addition_Sum2 (i.e. Get Sum of DataBand_Detail_Addition that Column "type" is not A )
DataBand_Detail_Deduction (Relation: DataBand_Master.Column "EmpNo" equals this.Column "EmpNo" )
DataBand_Detail_Deduction_Sum1 (i.e. Get Sum of DataBand_Detail_Deduction that Column "type" is A)
DataBand_Detail_Deduction_Sum2 (i.e. Get Sum of DataBand_Detail_Deduction that Column "type" is not A )
// Note Note Note
// Here insert following
DataBand_Detail_C_Sum1 (i.e. Get Sum of "DataBand_Detail_Deduction and DataBand_Detail_Addtion" that Column "T" is A)
DataBand_Detail_C_Sum2 (i.e. Get Sum of "DataBand_Detail_Deduction and DataBand_Detail_Addtion" that Column "T" is not A )
DataBand_Detail_Tax (Relation: DataBand_Master.Column "EmpNo" equals this.Column "EmpNo" )
DataBand_Detail_Tax_Sum1 (i.e. Get Sum of DataBand_Detail_Tax that Column "type" is A)
DataBand_Detail_Tax_Sum2 (i.e. Get Sum of DataBand_Detail_Tax that Column "type" is not A )
}
"DataBand1 Then DataBand1Total" nested inGroupBandFooter
"DataBand1 Then DataBand1Total" nested inGroupBandFooter
Last edited by high_pio on Wed Nov 23, 2016 4:36 am, edited 3 times in total.
Re: "DataBand1 Then DataBand1Total" nested inGroupBandFooter
Hello.
Sorry, maybe we don't understand your question right.
Could you describe your question more detailed with samples?
Thank you.
Sorry, maybe we don't understand your question right.
Could you describe your question more detailed with samples?
Thank you.
Re: "DataBand1 Then DataBand1Total" nested inGroupBandFooter
HighAley wrote:Hello.
Sorry, maybe we don't understand your question right.
Could you describe your question more detailed with samples?
Thank you.
>>> i reWrite my question. could you help me ?
Re: "DataBand1 Then DataBand1Total" nested inGroupBandFooter
Hello.
Did you try to use the SumIf() function?
You could read more about this function at the Syntax of Aggregated Functions and Totals with Condition sections of the User Manual.
Thank you.
Did you try to use the SumIf() function?
You could read more about this function at the Syntax of Aggregated Functions and Totals with Condition sections of the User Manual.
Thank you.