web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Delagation Sum

Power Apps

Answered

Delagation Sum

(0) Share

Report

Report

Posted on by ppenag78

5

I have this code and I hope you can help me improve it and that the delegation is not generated:

"With(

{

StartDate: Date(

Year(Today()),

Month(Today())-3, // cambiar numero

Day(Today())

)+1,

EndDate: Date(

Year(Today()),

Month(Today())-2, // Cambiar numero

Day(Today())

)

},

Sum(

Filter(

'Gasto Combustible',

IsBlank(ComboBox_Inncode.SelectedItems) || IsEmpty(ComboBox_Inncode.SelectedItems) ||

Inncode = ComboBox_Inncode.Selected.Value,

Fecha >= StartDate,

Fecha <= EndDate

),

Text(Value(Monto_USD),"#.##")

)

)

"

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ppenag78 ,

Could you please tell me what Monto_USD is ? If it is a text column, the formula can't be delegable.

Best Regard,

Bof

Was this reply helpful? Yes No
ppenag78 5 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft , Monto_USD is a number column, is the column I want to use to sum the result is this (attached)

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @ppenag78 ,

Please try:

With( { StartDate:Date(Year(Today()),Month(Today())-3,Day(Today()))+1, EndDate: Date(Year(Today()),Month(Today())-2,Day(Today())) }, Text( Sum( Filter( 'Gasto Combustible', IsBlank(ComboBox_Inncode.SelectedItems) || IsEmpty(ComboBox_Inncode.SelectedItems) || Inncode = ComboBox_Inncode.Selected.Value, Fecha >= StartDate,Fecha <= EndDate ), Monto_USD ),"#.##") )

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation