AnsweredAssumed Answered

Sum calculation with conditions?

Question asked by tinhx7 on May 21, 2017
Latest reply on May 25, 2017 by tinhx7

Screen+Shot+2017-05-07+at+9.15.26+AM.png

 

Hello guys,

 

My invoices layout is based on Line Items table.

The Tips amount is added on the Invoice.

One invoice can have multiple technicians perform for a client.

I"m try to add a subtotal of tips for specific week or day range for a specific tech on my Sales Reports.

Sales Reports are base on Line Items table.

Outcomes