Forum Discussion
Create a calculated column using another calculated column
Hi, I'm confronting a problem that I'm not able to solve. I request your help on this. I created a column by using the formula Impact_Mean= calculate(SUM(Append1[Total Impact])/SUM(Append1[...
Hi Anonymous ,
Could you please try below code:-
TEST = SWITCH ( TRUE (), TRUNC ( Append1[Impact_Mean] ) = 4 && TRUNC ( Append1[Probability_Mean] ) = 4, "4", TRUNC ( Append1[Impact_Mean] ) = 4 && TRUNC ( Append1[Probability_Mean] ) = 3, "1", TRUNC ( Append1[Impact_Mean] ) = 5 && TRUNC ( Append1[Probability_Mean] ) = 5, "2", "0" )BR,
Samarth
Anonymous can you share a screenshot of the table with these calculated columns and their result.
Sure.