if statement in Measure

[Vindy]

In red is a measured column which is 

% Scrap = ([Q4QTY minus Q4QTY 2]/[Production plus scrap])

How do I make %Scrap say PURCHASED if the purchased Parts = 2 and Qty Good Production is blank?

[mussaenda · Accepted solution]

Hi @Vindy ,

if you are willing  to convert your %Scrap to text,

Please try and substitute with your columnnames

VAR _Scrap% = 
( your % Scrap calculation ) * 100

RETURN

IF(
Purchased Parts = 2 && Qty Good Production = BLANK (),
"PURCHASED",

IF(
Purchased Parts = 1 && Qty Good Production = BLANK (),
_Scrap% & "%",

_Scrap% & "%"