Forum Discussion
sum condition
- Anonymous3 years ago
Hi LeaRupnik
According to the data and requirements you provided, you can not get the calculation results you want, I found several inaccuracies in the picture, you can refer to the comparison chart I provided
Here is my computed column code
NT = IF('Table'[PT]>'Table'[FT],0,'Table'[FT]-'Table'[PT])
Sum_NT = SUM('Table'[NT])
Best Regards,
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi LeaRupnik
According to the data and requirements you provided, you can not get the calculation results you want, I found several inaccuracies in the picture, you can refer to the comparison chart I provided
Here is my computed column code
NT = IF('Table'[PT]>'Table'[FT],0,'Table'[FT]-'Table'[PT])
Sum_NT = SUM('Table'[NT])
Best Regards,
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.