Creating a Dashboard using powerapps

[tscott07]

I have a powerapp that the users input their data and it is working. 

Now i have a task to do some calculations about the data from the first powerapp.  I want to just display this so i created another powerapp that pulls the connection from the SharePoint list of the first powerapp. 

I need do some calculations but not sure how to get the data i need onto the fields. 

I am stuck on 3 calculations.

1. MTD (Est value) i need to only get the current month est value based upon that fields due date.  I thought i could filter by duedate, Month(Now()) to get the items date but it says  it expects a text value???  I thought I would get the est contract value label i have and then filter it by the due date?

I will start with  this can anyone help??? I am working on a deadline. 

[tscott07]

I inserted this formula as well and nothing. 

[ZabiBabar]

What is the error that you get after inserting the formula?

[tscott07]

@ZabiBabar 

No the error was before i entered the formula: 

Text(Sum(Filter('Estimating List', Text(DueDate,"[$-en-US]m-yy") = Text(Now(), "[$-en-US]m-yy")), EstContractValue)), "$#,###0.00"))

i currently do not have any errors. but there is no result. 

[tscott07]

@WarrenBelz , @mdevaney 

Can you take a look at this formula and see what may be missing?

I need to sum the total for the items in this current month. 

Text(Sum(Filter('Estimating List', Text(DueDate,"[$-en-US]m-yy") = Text(Now(), "[$-en-US]m-yy")), EstContractValue)), "$#,###0.00"))

The due date field is a date field as 6/3/2020. estcontractvalue is a number field.