Forum Discussion
Anonymous
5 years agoNot applicable
OR function
This post has closed.
1 Reply
- Greg_DecklerCommunity Champion
Anonymous Well, here is the code cleaned up:
Yield %_latest_total = IF ( ( Fact_Yield_Detail_Latest[Item_Group_deduce] = "AP3" ) || ( Fact_Yield_Detail_Latest[Item_Group_deduce] = "AF1" ), CALCULATE ( SUM ( Fact_Yield_Detail_Latest[Good_Qty] ), Fact_Yield_Detail_Latest[Process_Description] = "Double Check" ) / CALCULATE ( SUM ( Fact_Yield_Detail_Latest[Start_Qty] ), Fact_Yield_Detail_Latest[Process_Description] = "Lathe Cutting" ), IF ( Fact_Yield_Detail_Latest[Item_Group_deduce] = "SP2 (toric)" || ( Fact_Yield_Detail_Latest[Item_Group_deduce] = "SP2 (non-toric)" ), CALCULATE ( SUM ( Fact_Yield_Detail_Latest[Good_Qty] ), Fact_Yield_Detail_Latest[Process_Description] = "Double Check" ) / CALCULATE ( SUM ( Fact_Yield_Detail_Latest[Start_Qty] ), Fact_Yield_Detail_Latest[Process_Description] = "UV mould prep" ), 0 ) )What I would suggest is to return hard coded values for each possible condition. Then you can check your logic.