I am trying to apply formula on two columns and create another column that would hold the result.
i used formula to achieve this. However, the formula applies it to all the rows. My formula was IF [Employee Name] = "Pavithra" and [Percentage] >0.1 then "More than 10%" else "Not achieved the threshold" endif
Please help
Solved! Go to Solution.
We can use a table tool to color it. Color is determined in the multi-row formula tool
Output:
Output:
Workflow:
Render tool is required to output to excel with formatting
Hope this helps🙂
brilliant!!!! Thank you for all your assistance @atcodedog05
Hi @atcodedog05
Is there a way , if percentage field is of the type "V_String" to be compared with numbers.
for eg: Lets say percentage is of type "V_String" can the following operation be done
IF [Employee Name] = "Pavithra" and [Percentage] >0.1 THEN "More than 10%" ELSEIF [Employee Name] = "Kishore" and [Percentage] >0.6 THEN "More than 60%" // add more elseif for conditions ELSE "Not achieved the threshold" ENDIF
You can use ToNumber() function like ToNumber([Percentage]) to convert string to number.
IF [Employee Name] = "Pavithra" and ToNumber([Percentage]) >0.1 THEN "More than 10%"
ELSEIF [Employee Name] = "Kishore" and ToNumber([Percentage]) >0.6 THEN "More than 60%"
// add more elseif for conditions
ELSE "Not achieved the threshold" ENDIF
Hope this helps 🙂
IF [Employee Name] = "Pavithra" and ToNumber([Percentage]) >0.1 THEN "More than 10%"
ELSEIF [Employee Name] = "Kishore" and ToNumber([Percentage]) >0.6 THEN "More than 60%"
// add more elseif for conditions
ELSE "Not achieved the threshold" ENDIF
@atcodedog05 this time you are slightly faster then me 🙂
Hi @atcodedog05
When the render tool is used to output the table, I see in my excel extract most of the headings, values within them are cut off. I tried change the margins etc., but that didnt help.
Could you suggest?
Even i faced that issue. I dont know the cause or how to fix it.
Sorry 😶
Maybe you can post it as a new question and people will help you.