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
OOlashyn
MVP

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
OOlashyn
MVP

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
Welcome Super Users.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,901)