Skip to main content

Hi All,

 

I am trying to create a report that can show what is our running balances on sales to meet our quota, i use invoices and memos as my references for the report, and group it by doc type, and on the formula for the running balances is =IIf(fARInvoice.DocType]='CRM', 10000000+SUM(MARInvoice.CuryLineTotal]), IIf(fARInvoice.DocType]='INV', ((10000000-SUM(MARInvoice.CuryLineTotal]))*(-1)), IIf(fARInvoice.DocType]='DRM', ((10000000-SUM(MARInvoice.CuryLineTotal]))*(-1)), 0)))

how can i end up on the correct report for this 

 

Hi @Jov29 ,

I don’t think it’s possible to calculate a running total in a Generic Inquiry.  You could do this in the Report Designer by using variables.  

Laura


Hi @Jov29 ,

I don’t think it’s possible to calculate a running total in a Generic Inquiry.  You could do this in the Report Designer by using variables.  

Laura

Hi Laura, 

 

Thanks for responding, i will try to use report designer for the running total. 


Reply