-
HI Ms. Hilary.
As you can see in the photo, total hours for 30 row is 184
- If I select Project assigned with LLM ( 3 row - 1Non Bill and 2 Bill)
- After that, I click to Project Filter = Total hours should be Sum of 3 Rows = 24
- Then If I click to Bill of Project Filter, Bill Total hours should be 16 hours
But in the form it still Sum ...
-
-
-
So - I just want to make sure I understand. You need help adding the project filter to the two Total fields, outlined in the screenshot?
-
Thank you, Hilary, you always come through!
-
hi.
i attached my real form.
example:
Project Assigned Column I select A B C with Bill or Non Bill
so In project site I will Filter Project with Bill/ Non Bill+ Project Assigned .So the Total Hour will be rẽcalculate also
-
I'm not sure I completely understand the question, but am attaching a sample with a table of distinct types & sites and subtotals for those. Hopefully it helps. :)
-
Dear Ms. Hilary,
Can you help me with one 1 condition.
In your form, I want to make filter of SUM TOTAL by Type and Site. Can we do it? If yes, could you please help me.
Thanks
-
Give the attached sample a try.... I used a default value to calculate the date time string from the fields, and you'll see I used some substring function to zero pad the hours field if needed. Then on the submit button, I compare that calculated field to now() + 1 to see if the datetime is > 24 hours away. Right click the linked file, save ...
-
Whew, it's been a while since I've had to be on here.
Here's the problem I'm up against: working on modifying an existing form that has a date field (date), a start hour field (whole number), and a start minute field (whole number). I'm trying to calculate the full date/time with those fields so that I can then compare the ...