Formatting calculated sum in document

Documents
1

Hi, I'm looking to format the Grand Total at the bottom to USD. I can get the column Payment with format(C), but is it possible to do the sum in the same way?

image
image894×216 10.1 KB

2

Never mind, {{lumpSumItems}:sum(value.payment):format(C)} worked. when I tried it before, I had a typo in it so I thought it didn't :sweat_smile:

1 Like
3

Thank you for the update, Emily!