cumulative sunday attendance.lava

{%metricvalue where:'MetricId == 990' sort:'MetricValueDateTime desc' limit:'1'%}
    {% for metricvalue in metricvalueItems %}
        {% capture currentWorshipAttendance %}{{ metricvalue.YValue | Format:'#,##0' }}{% endcapture %}
    {% endfor %}
{% endmetricvalue %}
{%metricvalue where:'MetricId == 1117' sort:'MetricValueDateTime desc' limit:'1'%}
    {% for metricvalue in metricvalueItems %}
        {% capture currentChapelAttendance %}{{ metricvalue.YValue | Format:'#,##0' }}{% endcapture %}
    {% endfor %}
{% endmetricvalue %}
{%metricvalue where:'MetricId == 1098' sort:'MetricValueDateTime desc' limit:'1'%}
    {% for metricvalue in metricvalueItems %}
        {% capture currentKidsWorshipAttendance %}{{ metricvalue.YValue | Format:'#,##0' }}{% endcapture %}
    {% endfor %}
{% endmetricvalue %}
{%metricvalue where:'MetricId == 1108' sort:'MetricValueDateTime desc' limit:'1'%}
    {% for metricvalue in metricvalueItems %}
        {% capture currentWorshipServingAttendance %}{{ metricvalue.YValue | Format:'#,##0' }}{% endcapture %}
    {% endfor %}
{% endmetricvalue %}
{%metricvalue where:'MetricId == 1110' sort:'MetricValueDateTime desc' limit:'1'%}
    {% for metricvalue in metricvalueItems %}
        {% capture currentOnlineAttendance %}{{ metricvalue.YValue | Format:'###0' }}{% endcapture %}
    {% endfor %}
{% endmetricvalue %}

{% assign previousSunday = 'Now' | SundayDate | DateAdd:-7 | Date:'MM-dd-yyyy' %}

{{ currentWorshipAttendance | Plus:currentChapelAttendance | Plus:currentKidsWorshipAttendance | Plus:currentWorshipServingAttendance | Plus:currentOnlineAttendance }}, {{ previousSunday }}