Hello @needfeed
Thank you very much for using our plugin. You can do something similar to the following equation:
SUM(SUM(fieldname12, fieldname8, fieldname11).toString().split(''));
And that’s all.
Best regards.
I tried with January (value is 1) 1st (value is 1), of 1991 (value is 1991), and the number is double digit: 22
Can we make it single digit? 2+2=4?
https://ibb.co/80qdfMX
And how does it look like with sum of YEARS number only (fieldname12) to a single digit?
Thanks for your help 🙂
Hello @needfeed
If you want to repeat the process until the result be lower than 10, you can use a loop statement. Like:
(function(){
var result = SUM((fieldname12).toString().split(''));
while(10 <= result) result = SUM((result).toString().split(''));
return result;
})()
Best regards.
Yes, this formula with years sum is working fine.
I tried this formula with all the date sum, but somethings wrong here?
(function(){
var result = SUM((fieldname12, fieldname8, fieldname11).toString().split(”));
while(10 <= result) result = SUM((result).toString().split(”));
return result;
})()
Hello @needfeed
In your case, you must use the SUM operation twice.
The first time you must sum the fields, and then their digits.
In my example, it is unnecessary because it sums only the digits of a single field.
So, the equation would be:
(function(){
var result = SUM(SUM(fieldname12, fieldname8, fieldname11).toString().split(''));
while(10 <= result) result = SUM((result).toString().split(''));
return result;
})()
Best regards.
Thank you, codepeople, calculator is working fine 🙂
