Hello, I want to calculate the crossfoot of each content of a cell like:
FIELD1 | RESULT 123 | 6 0145 | 10 34 | 7 and so on.
Is there an possibility in QV to realize that without dividing each number into single digit fields to get the sum of the digits as crossfoot? Thanks in advance.dj
I have been brooding over that for two months but had no idea. The best I could find for now is provided in enclosed little sample which works with MapSubstring and evaluate ... Have a look at it, perhaps it helps.
I have been brooding over that for two months but had no idea. The best I could find for now is provided in enclosed little sample which works with MapSubstring and evaluate ... Have a look at it, perhaps it helps.
Another proposal (which would of course involve module script) would be a function as shown in my enclosed demo. This would be the most flexible and most transparent solution (of course one could surely still improve the algorithm behind the function itself, but it's working good enough for demonstration purposes), working also with commas, negative values etc and evaluate independent on the numbers of digits (as my former proposal which is of course not as slim). The only downside I can see for now is as said the involvement of a module script.
Hello, Rob's solution works for my requirement (0,1,2,3,4 max.possible char=9) but one must be aware of the number of characters otherwise it would be uncertain. --- Joachim's second solution also is fine but with the lack being outside the script.
Perhaps QV will implement a crossfoot function into standard because assessing severities in form of cumulating digits is routine in some branches.
