cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
esjimenezp
Helper V
Helper V

Combine Text and Sum

Hi Community,

 

I will like to add the next formula to Default property, but the field is give me an error, the intention is to get the sum of two fields.

Text(
    varStatusReport.EndofYearEstimate, "[$-en-US]$#,##.00", sum(txt_ActualCostToDate + txt_LeftToDo))

 

esjimenezp_0-1660071748522.png

Kind regards 👋

 

1 ACCEPTED SOLUTION

Accepted Solutions
Krishna_R
Responsive Resident
Responsive Resident

Hi @esjimenezp 

 

what is varStatusReport.EndofYearEstimate here ?

If the intention is only to add two fields try below

 

Text(Value(txt_ActualCostToDate.Text) + Value(txt_LeftToDo.Text),"[$-en-US]$#,##.00")

 

View solution in original post

4 REPLIES 4
Krishna_R
Responsive Resident
Responsive Resident

Hi @esjimenezp 

 

what is varStatusReport.EndofYearEstimate here ?

If the intention is only to add two fields try below

 

Text(Value(txt_ActualCostToDate.Text) + Value(txt_LeftToDo.Text),"[$-en-US]$#,##.00")

 

SBax
Impactful Individual
Impactful Individual

By the looks of it you have multiple formulas in here, try separating the formulas with & symbols 

esjimenezp
Helper V
Helper V

Awesome @Krishna_R the intention of the varStatusReport.EndofYearEstimate is to get the value from the SharePoint list when the user select the item from the Gallery, thanks for your help 😎

 

Kind regards 👋

thanks @SBax I will for my next formulas into my apps, I really appreciate your comment, thanks.

 

Kind regards 👋

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps 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.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,822)