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: https://hizl...
Anonymous
Just move the right parenthesis.
) * [L8 için Plan]
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])
v-chuncz-msft
Community Support
Community SupportAnonymous
Just move the right parenthesis.
) * [L8 için Plan]