Hello everyone,
I’m a little confused about how to use the total function I have a subform, where I need to add numbers. With the total function this is no problem, but I only need the Data to be added, when one Datefield is empty. I’m looking for something like the “summewenns” function in the Numbers-APP.
Is there something like this ready, or do I have to use a script to calculate everything on my own?
Thanks for any hint
Steve
Hi Steve,
I don’t know what summewenns means and translation didn’t find it either. But if you need to add a number only when a Date field is empty, then you’ll need either a Calculation field or a Script field to return that value for you. Then you can have the grand total displayed for that field.
In a Calculation field, use the IFEMPTY() function to detect if your date field is empty or not.
summewenns is a Funktion from apple numbers Programm. that is why you can not find a translation, sorry for the confusion,
you mention the calculation field. I’m using it in several forms but how can I tell the filed to only add the values with an empty date field? via script I have found out but I thing using existing function would be easier, that is why I ask :)
Greetings
Steve
You create an additional field (type: calculation) that only contains a number when the respective date field is empty. Then you can use the total feature on that.
Cheers, Daniel
---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks
.
