Combine Text and Sum

[esjimenezp]

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))

Kind regards 👋

[Krishna_R · Accepted solution]

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]

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

[esjimenezp]

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 👋

[esjimenezp]

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

Kind regards 👋