I've currently got an invoicing system in FM which works fine, table for customers, invoices, products, and line items etc. I've got the overall gross profit showing on each invoice, however, I now want to split this down to show the gross profit for materials and gross profit for labour.
I've got a radio button on each product where you select either material or labour so I'm hoping to use that to define which line items should be used in the calculation. So when an invoice is created with products that are both labour and materials I'd like the two separate gross profits to show.
I've tried creating a calculation using an if statement to check what type a line item is, however, this does not seem to be working.
Please, could someone point me in the right direction, or confirm if this is possible?