you could define 3 calc fields:
TillAmountCash = if (TillMethod = "Cash"; TillAmount; 0)
TillAmountCard = if (TillMethod = "Card"; TillAmount; 0)
TillAmountCheque = if (TillMethod = "Cheque"; TillAmount; 0)
and 3 summary fields, 1 for each, being SUM(TillAmountxxx) and sitting in a subsummary part as well as in a trailing grand summary part.
Thanks so much for that! Worked perfect...
I'm now having issues with reporting over a certain date range. If i use filemakers own find I can type the date and it will find all the matching records however I cant seem to manage it with scripting....
Currently using this script and it keeps telling me the find criteria is not valid...
is there a relationship such that you can reach tblDate from tblCashBill ?
dont worry, thanks for all your help.
Turns out I had missed out on clicking the global field in one of the fields.