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 👋
Solved! Go to 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")
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")
By the looks of it you have multiple formulas in here, try separating the formulas with & symbols
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 👋
User | Count |
---|---|
250 | |
105 | |
82 | |
51 | |
43 |