Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
@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
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"
can you attached a sample data and the expected output? @simonecimino
I would like to get the column highlighted in red. @Taoufiq_Zarra
Dimension: Importo Incasso and IDENTICATIVO BONIFICO
and measure :
sum(total <[IDENTICATIVO BONIFICO]> [Importo Incasso])
output:
@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)
@simonecimino that's why I ask for the initial input
@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.