Create an Expression with multi substracting

[#1]

Good morning, I need to do the following:

I have a field called CAUSALE that can take multiple values (FE, IN, NC, IP).

I have to create an expression to perform a subtraction between a field called CNIMPF and field CNRATA when CNCAU has a certain value (IN or IP). The subtraction can have more of a subtracting based on how many are the occurrences of the value IN in the field CNCAU

For example it's possible to have this situations:

CNIMPF - (CNRATA-CNRATA-CNRATA-CNRATA-CNRATA)

CNIMPF - (CNRATA -CNRATA-CNRATA)

CNIMPF - (CNRATA)

It's possible to do ?

Thanks

Giovanni

[sunny_talwar]

Not exactly sure what you are trying to accomplish here, would you be able to give an example here? (May be a sample qvw)

Best,

S

[MK_QSL]

Can you provide sample data along with your exact expectations?

[#4]

Hi, I attache an example of a file.

What I do is this:

The field RESIDUO is the difference of the FIELD "IMPORTO FATTURA - IMPORTO SCADENZA".

In case there are two lines in this case for the field "NUMERO FATTURA", you need to either the residual is calculated as "IMPORTO SCADENZA" where field CAUSALE is "FE" less "IMPORTO SCADENZA" where the field is equal to IN.

It 'possible that there are multiple lines for the field "CAUSALE" equal to "IN".