Workbench - Quickbook respect negative values...

When connecting QuickBooks to DOMO, some of the imported categories are tagged as expenses and thus subtracted from income. 

When imported into Domo, they all show positive and only add. Any ideas on how to fix this?

 

Thanks!

Comments

  • kshah008
    kshah008 Contributor

    Hi all,

     

    Can anybody help @greynoso with his question?

  • nalbright
    nalbright Contributor

    How are you importing your quickbooks?  It is possible that one would need to create a beast mode calculation that would subtract certain categories from income, at least as a workaround.

    "When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam
  • jeremyhurren
    jeremyhurren Domo Employee

    I think typically the QuickBooks data comes in in different columns, so the amount is either in the credit or debit column, rather than being positive or negative. I think you create a calculated field in Workbench that would pull the right amount. Use a calculation along the lines of (sorry I can't provide an exact answer since I am not in front of my Workbench instance at the moment, but hopefully this can get you going):

     

    IF(Debit>0,Debit,-Credit)
  • kshah008
    kshah008 Contributor

    @greynoso, did any of the above responses help address your issue?

This discussion has been closed.