Hi,
I’m new to TFP so probably a silly question.
Having a table (form) with columns including Cost and Checkboxes ToProcess and Processed; I would like to have a summed total of the Cost of all records that are marked ToProcess TRUE AND Processed FALSE.
What would be the best way to get this?
Thanks,
Michael
I would add a calculation field that uses following formula: IF( [ToProcess] & [Processed]=FALSE ; [Cost]; 0). Then you can use the total for that column as shown below.
Attachments:
You must be
logged in to view attached files.
Cheers, Daniel
---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks
Hi Daniel,
Thank you very much, this is definitely a quick workaround.
In the long term I’m looking for a “reporting solution” as the table will quickly have thousands of records which will make it a bit cluttered.
Cheers,
Michael
Hi Michael,
If your data is in a form, you can use saved searches and filter for your condition. This way, only the relevant records are shown. When you look at them in multi-column list view, you can get your total costs.
Sometimes, I write scripts for reporting and display the result in an external browser.
Cheers, Daniel
---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks
Thanks again Daniel!
I will look into this
.
