user00003 Member

Comments

  • The flex table in Analyzer works but...the next part of this is to subtract out another account to get another value. I tried the ETL but there must be way too much data because it ran for 20 hours before I canceled it. So I'm not sure where to go from here. In the end I need (AR beginning balance - AR Ending balance) -…
    in Previous month ending balance as current Month Beginning Balance Comment by user00003 April 2019
  • For example if I had the below data on the left I want the columns on the right. It has the AR beginning balance for February as the AR blanace that was in January. DateAccount NameAmount AR Beginning balanceAR Difference Jan-19Unbilled Sales105162 Jan-19AR Balance81963 AR Balance from DecemberDec Balance-81963…
    in Previous month ending balance as current Month Beginning Balance Comment by user00003 April 2019
Default Avatar