When I used this operation (wrong data type) I got an error I want to get the average of the formula below . What is the correct formula for getting the average of @DocDescendants and @DocChildren? Or is there an alternate way to calculate the category and sub class, then get average for each category?
avg: = @ DocDescendants / @DocChildren;
Or even
average: = @ text (@docdentents / doc hair);
avg: = @ toNumber (@DocDescendants) / @ToNumber (@DocChildren) @DocDescendants ("%") Really stiff documents and @Doc child's actual Returns with the number; "
%") will return the number of hair records, if you leave "%" Return value is unused 'special text', there are other optional parameters which are well documented in Domino Designer Support.
Note: "%" returns a string so that to calculate the average, you have to wrap the value in @textToNumber, to wrap the calculation in @error to handle the docs with any feedback It may be necessary, which means that attempting to divide a division with all this might seem complicated, and once again in Formula's language on Lotus to make a complaint And the reason is,
Comments
Post a Comment