cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KellyMcLaren
Frequent Visitor

Get subtotal of liquid variables in table

Hello,

I am new to PowerApps so please bare with me. In my Portal I have a Web Template where I am using FetchXML to get data. I have a table (screenshot attached) and am trying to get the Subtotal of all values in the Total column.

 

My Total column looks like this: 

 

 

        <td class="linetotal">{% assign linetotal = routineCount.results.entities.size | times: {{result.obj_price | format: "c" }} %}
        {{linetotal}}</td>

 

 

 

I have spent some time trying to get the total sum using Liquid & JS/JQ but nothing seems to work. Any help or tips would be appreciated! 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @KellyMcLaren ,

 

You can just create another variable and add to it your linetotal after each time you calculate it. 

----------------------------------------------------
If you find this post helpful consider marking it as a solution to help others find it.

View solution in original post

1 REPLY 1

Hi @KellyMcLaren ,

 

You can just create another variable and add to it your linetotal after each time you calculate it. 

----------------------------------------------------
If you find this post helpful consider marking it as a solution to help others find it.

Helpful resources

Announcements
Carousel Community Blog

Check out the Community Blog

Read all about the most recent blogs in the community!

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Carousel News & Announcements

What's New in the Community?

Check out the latest News & Events in the community!

Users online (3,092)