Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
How to approch this kind of problem.
Not able to implement
Stock=IF(SUMIF(Data!J:J,REPORT!$A6&"NEWBHW",Data!D:D)=0,
SUMIF(Data!J:J,REPORT!$A6&"NEXBHW",Data!D:D),SUMIF(Data!J:$J,REPORT!$A6&"NEWBHW",Data!D:D))
Thanks
Hi @Anonymous ,
Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |