Hello Support,
Our list data consists of lines for Hours and Expenses, with subtotals for each.
On the attached template, how do I do that with the existing conditions?
The table should display as below:
PTIN0025176 - AECPMIPPSAProjInvoice.PMIPProjectInvoicing.ddsp (310.0 KB)
PTIN0025176_editing_v1 (Edited).docx (98.3 KB)
Hi @Nicky,
I’ve looked at your dataset, and it’s hard to tell when a line is for hours and when it’s for expenses.
I see that you are always using the data field called PMIPDescription for your grouping and extracting some data from it. However, the costs are located in different parts of the string, making it hard to extract them correctly.
Could you please clarify or give more details on how this should be grouped and based on which data field?
I recommend checking with the developer to include an additional data field for the cost data, instead of extracting it from the description.
Hi Amir,
The expenses lines do not have a number in the Quantity field - will we be able to use that temporarily to distinguish? Our developer is looking at adding a Transaction Type field to make the split easier.
Hi @Nicky,
Do you mean to put numbers in the Quantity field to represent different groups?
Like, if the number 1 is in the field, it means Hours, and if the number 2 is in the field, it means Expenses, and so on?
