Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to write an expression for a chart that says if the bill date field is populated, sum the total request amount. I have most of it but I don't know what to put in place of 'Billed'. Any suggestions?
=sum(if([[Bill Date]]= 'Billed', [Total Request Amount]))
Try
=sum(if(Len(trim([Bill Date]))>0, [Total Request Amount]))
Hmmm...I underestimated the complexity.
I want to show a few things:
Invoices with LOG
Sum (Total Request Amount) if LOG Received (checkbox) = Yes and Invoice Received (checkbox) = Yes and Bill Date (date) = Blank.
Missing a LOG
Sum (Total Request Amount) if LOG Received (checkbox) = No and Invoice Received (checkbox) = Yes and Bill Date (date) = Blank.
Missing an Invoice
Sum (Total Request Amount) if LOG Received (checkbox) = Yes and Invoice Received (checkbox) = No and Bill Date (date) = Blank.