AnonymousNot applicable5 years agoSolvedIf not, result errorThe formula used is given in the screenshot. If length, width, height >0 then "YES" plus "No"Els calerof to Anonymous5 years agoHello @sbhan4 , Try this:GPPCheck = SWITCH( TRUE(), SUM(GPP[Height]) <= 0 || SUM(GPP[Lenght]) <= 0 || SUM(GPP[Width]) <= 0, "No", "Yes" ) I hope it helps.Best regardsFernando If it helped, please consider liking the post and mark it in response.
calerof to Anonymous5 years agoHello @sbhan4 , Try this:GPPCheck = SWITCH( TRUE(), SUM(GPP[Height]) <= 0 || SUM(GPP[Lenght]) <= 0 || SUM(GPP[Width]) <= 0, "No", "Yes" ) I hope it helps.Best regardsFernando If it helped, please consider liking the post and mark it in response.
calerof to Anonymous5 years agoHello @sbhan4 , Try this:GPPCheck = SWITCH( TRUE(), SUM(GPP[Height]) <= 0 || SUM(GPP[Lenght]) <= 0 || SUM(GPP[Width]) <= 0, "No", "Yes" ) I hope it helps.Best regardsFernando If it helped, please consider liking the post and mark it in response.
14 RepliesReplies sorted by Most LikedcalerofImpactful Individual5 years agoAnonymous Are you using Width or Weight?FAnonymousNot applicable to calerof5 years agocalerof width calerofImpactful Individual to Anonymous5 years agoAnonymous You're not showing the Width column in your screen-shot. It'd be helpful if you share a sample of your data.F Show More
calerofImpactful Individual to Anonymous5 years agoAnonymous You're not showing the Width column in your screen-shot. It'd be helpful if you share a sample of your data.F
Related contentCalc not resulting in Percentage?!MLFlow - Not logging results of all epochsSAMEPERIODLASTYEAR not giving correct resultsUnexpected error: Arithmetic operation resulted in an overflow.% result errors using dax
