topic Re: Add specific values in the table in App Development

Add specific values in the table

simonecimino — Thu, 10 Jun 2021 07:41:46 GMT

Good morning,
do you know how to add the values of the "Importo incasso" column for each "IDENTIFICATIVO BONIFICO"?

So if I have 3 lines with the same "IDENTIFICATIVO BONIFICO" I would like to display the total sum of "Importo Incasso" for that "IDENTIFICATIVO BONIFICO"

Re: Add specific values in the table

Taoufiq_Zarra — Thu, 10 Jun 2021 07:55:26 GMT

@simonecimino if i understood correctly

sum(total <[IDENTIFICATIVO BONIFICO]> [Importo Incasso])

if not can you share a sample data and the expected output in table format

Re: Add specific values in the table

simonecimino — Thu, 10 Jun 2021 08:09:11 GMT

Thanks for the reply @Taoufiq_Zarra

I tried what you suggested. However, I expect to find the total sum for each line, so 115.24 repeated on the 3 lines that have that "IDENTIFICATIVO BONIFICO"

Re: Add specific values in the table

Taoufiq_Zarra — Thu, 10 Jun 2021 08:13:09 GMT

can you attached a sample data and the expected output? @simonecimino

Re: Add specific values in the table

simonecimino — Thu, 10 Jun 2021 08:26:09 GMT

I would like to get the column highlighted in red. @Taoufiq_Zarra

Re: Add specific values in the table

Taoufiq_Zarra — Thu, 10 Jun 2021 08:51:11 GMT

@simonecimino

Dimension: Importo Incasso and IDENTICATIVO BONIFICO

and measure :

sum(total <[IDENTICATIVO BONIFICO]> [Importo Incasso])

output:

Re: Add specific values in the table

simonecimino — Thu, 10 Jun 2021 09:18:28 GMT

@Taoufiq_Zarra Unfortunately I don't get the same output ... I probably have some problems in the inputs ...

I get "IDENTIFICATIVO BONIFICO" like this

=If(WildMatch([CSVexport (1).Descrizione],'*'&Fatture&'*'), TextBetween([CSVexport (1).Descrizione], 'Cro: ', ' Note:'))

and I get "IMPORTO INCASSO" like this

= If(WildMatch([Fatture],'*'&S_FATTURA_DEF&'*'), TOTALE_IMPORTO)

Re: Add specific values in the table

Taoufiq_Zarra — Thu, 10 Jun 2021 09:37:29 GMT

@simonecimino that's why I ask for the initial input

Re: Add specific values in the table

simonecimino — Thu, 10 Jun 2021 09:40:14 GMT

@Taoufiq_Zarra Sorry, I don't understand. In input I have two separate excel files and I get "IDENTIFICATIVO BONIFICO" and "IMPORTO INCASSO" as I explained above.