About Multiply the filtered value (Yesterday )

[Anonymous]

Hello,

I filtered from the yesterday column in the Excel table and I reached what workday we were.

Remaing workday = IF(Table1[Date]=TODAY()-1;Table1[Work Days])

My table:

https://hizliresim.com/r7S5xD

And Result: 

https://hizliresim.com/WO1qxY

I have no problem in this part.

I want to multiply the number on a column and the table above, but I couldn't. 

The workdays that appear for the yesterday I did above are not working in the multiplication process.

IF(Table1[Date]=TODAY()-1;Table1[Work Days])*[L8 için Plan]

The filter does not work in this code, and the multiplication table gives a very high number. I want it to multiply the data for yesterday. 

What do you recommend?

[Anonymous]

That's what I want to do:
17*1.685.756

According to the figures I mentioned in the table, he will perform the multiply with the figure of -1 day.

https://hizliresim.com/r7S5xD * https://hizliresim.com/wcbRwY

I am trying the code below but it gives a very different result. The result should be 28,657,852.

test = SUMX(FILTER(Table1;Table1[Date]=TODAY()-1);Table1[Work Days]*[L8 için Plan])

https://hizliresim.com/4QgSX9

[v-chuncz-msft · Accepted solution]

@Anonymous 

Just move the right parenthesis.

) * [L8 için Plan]