Forum Discussion

jrpoli2000's avatar
jrpoli2000
Frequent Visitor
8 years ago
Solved

Value adjustment

  Can anyone please help me with 2 measures or calculated columns to make adjustments on INVOICE PAYMENT and PENDING columns. ADJUSTED INVOICE PAYMENT column will only calculate the rows with negati...
  • JDLee23's avatar
    JDLee23
    8 years ago

    Not an amazingly elegant solution, but this should work:

     

    Add two calculated columns as below - 

     

    Adjusted Invoice Payment = IF ( Pending < 0 , InvoicePayment - Pending, InvoicePayment )

     

    Adjusted Pending = IF ( Pending < 0, 0, Pending )

     

    Hope this helps!

     

JDLee23's avatar
JDLee23
Helper I
8 years ago

Not an amazingly elegant solution, but this should work:

 

Add two calculated columns as below - 

 

Adjusted Invoice Payment = IF ( Pending < 0 , InvoicePayment - Pending, InvoicePayment )

 

Adjusted Pending = IF ( Pending < 0, 0, Pending )

 

Hope this helps!

 

  • jrpoli2000's avatar
    jrpoli2000
    Frequent Visitor
    8 years ago

    Thanks a lot!!! You just cured my weeklong headache:smileyhappy: