Net value of field DMBTR

[former_member254442]

Hi All,

In table AUFM, value of field DMBTR always shows positive irrespective of field SHKZG value " H" or "S" ( debit or credit) . In calculation view , I need to show net value . Instead of creating of 2 calculation view , is there any SQL statement I can use to get the net value ?

Thanking you in advance .

[pfefferf]

Hi,

why are you not using a calculated column to calculate your net value?

E.g. with following expression:

if("SHKZG" = 'H',"DMBTR", "DMBTR" * -1)

Regards,

Florian

[former_member254442]

Thanks for the response . Suppose ,I have DMBTR = 120 EUR with SHKZG = H and DMBTR = 100 EUR with SHKZG = S . Will value of calculated column be  20 EUR  with above statement ?

[pfefferf]

The calculated column is the first step you wanna reach. On the calculated column than you have to do an aggregation over the required attributes.

Regards,

Florian