Forum Discussion
About Multiply the filtered value (Yesterday )
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:
And Result:
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
Just move the right parenthesis.
) * [L8 için Plan]
2 Replies
That's what I want to do:
17*1.685.756According 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])
v-chuncz-msftCommunity Support
Anonymous
Just move the right parenthesis.
) * [L8 için Plan]