Record count.

Hi, I’m making a summary report I know how to do it, but I’ve a little question,

Let me first show the data that must be summarized

[TABLE=“border: 0, cellpadding: 0, cellspacing: 0, width: 180”]
[TR]
[TD=“width: 80”]IdProject[/TD]
[TD=“width: 80”]City[/TD]
[TD=“width: 80”]Value[/TD]
[/TR]
[TR]
[TD=“align: right”]100[/TD]
[TD]Bogota[/TD]
[TD=“class: xl63”] $ 1,000.00[/TD]
[/TR]
[TR]
[TD=“align: right”]100[/TD]
[TD]Lima[/TD]
[TD=“class: xl63”] $ 3,500.00[/TD]
[/TR]
[TR]
[TD=“align: right”]300[/TD]
[TD]Buenos Aires[/TD]
[TD=“class: xl63”] $ 4,000.00[/TD]
[/TR]
[TR]
[TD=“align: right”]400[/TD]
[TD]Lima[/TD]
[TD=“class: xl63”] $ 500.00[/TD]
[/TR]
[TR]
[TD=“align: right”]400[/TD]
[TD]Santiago[/TD]
[TD=“class: xl63”] $ 700.00[/TD]
[/TR]
[TR]
[TD=“align: right”]400[/TD]
[TD]Caracas[/TD]
[TD=“class: xl63”] $ 800.00[/TD]
[/TR]
[/TABLE]

Tb1: Data Detail

[TABLE=“border: 0, cellpadding: 0, cellspacing: 0, width: 352”]
[TR]
[TD]Etiquetas de fila[/TD]
[TD]Cuenta de IdProject[/TD]
[TD]Suma de Value[/TD]
[/TR]
[TR]
[TD]Bogota[/TD]
[TD=“align: right”]1[/TD]
[TD=“align: right”]1000[/TD]
[/TR]
[TR]
[TD]Buenos Aires[/TD]
[TD=“align: right”]1[/TD]
[TD=“align: right”]4000[/TD]
[/TR]
[TR]
[TD]Caracas[/TD]
[TD=“align: right”]1[/TD]
[TD=“align: right”]800[/TD]
[/TR]
[TR]
[TD]Lima[/TD]
[TD=“align: right”]2[/TD]
[TD=“align: right”]4000[/TD]
[/TR]
[TR]
[TD]Santiago[/TD]
[TD=“align: right”]1[/TD]
[TD=“align: right”]700[/TD]
[/TR]
[TR]
[TD]Total general[/TD]
[TD=“align: right”]6[/TD]
[TD=“align: right”]10500[/TD]
[/TR]
[/TABLE]

Tb2: Summarized data

Well I didn’t see into scriptcase "Totals"section an option for count the values inside a column in this case IdProject.

I apreciate your help.

Thanks

Search for Totalling Variables in sc macros doc

Thanks Giu,

unfortunately it doesn’t work, I need to remove the totalization of record count in the summary but by setting those variables it not can be done

I just need modify the number of total records, I tried the following {count_ger}=$RecalculatedTotal, or simply hide the total for count of records but it can’t be done.