Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Custom Calculation

TESTED

Overview

Calculate custom formulas based on your accounts balance

Calculation

Select the accounts to include in your formula from the drop-drown. From the input box on the right hand side, the formula can be adjusted based on the selected account.

Example

To compute the Accounts Receivable to Accounts Payable Ratio, you need to divide the Accounts Receivable balance by the Accounts Payable balance. To do so

  • Select Accounts Receivable and then Accounts Payable from the drop-down
  • Accounts will be annotated as "1 - Accounts Receivable" and "2 - Accounts Payable"
  • Enter this formula: "{1} / {2}"
  • The result will be displayed on your widget after saving

 


 

 

 



 

 

 



 

 


 

  • No labels