vLookup Totals

[Danielle Arcuri]

Hello, I am trying to figure out a way to total up two columns in my child my list not based on numbers. The first column i want a total to count if the item column = yes. The second column i want to count is if it is not blank. Is that possible?

[Alexander Bautz]

There is unfortunately no custom totals function that will let you sum up only “Yes”, but you can count not blanks by adding this to the special configuration:

{"totalsType":"count"}

Using this method you can create a calculated column that only shows your “Yes” values and shows “No” as blank – that will give you a sum of your “Yes” values.

Alexander

[Danielle Arcuri]

Ok thank you, and how can i get the totals row to be left aligned instead of right aligned

[Alexander Bautz]

By default all “totals” are right aligned, but you can use override this in your “Special configuration” for the field like this:

{"totalsType":"count","css": "text-align:left"}

Alexander

[Author]

Posts