Total of Date Numbers

1st Total

prop("Date") 
	? prop("Date")
		.formatDate("DD/MM/YYYY")
		.replaceAll("/")
	.split("")
		.map(
			current
			.toNumber()
		)
		.sum()
	: 0

2nd Total WIP

if(length(format(prop("1st Total"))) > 1, if(test(format(prop("1st Total")), "11|22|33"), prop("1st Total"), toNumber(slice(format(prop("1st Total")), 0, 1)) + toNumber(slice(format(prop("1st Total")), 1, 2))), prop("1st Total"))

By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!