Skip to Content

Net value of field DMBTR

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 .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 06, 2016 at 05:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded