referencing a formula within another

Question

Hi,

I am trying to adjust my formula for this:

and when I transpose I get this:

But OE Conclusion should have "Field Requires a value" correspond to it in the Exception column.

My formulas

after i do this i transpose to the result you see above.

What am I doing wrong?

wonka1234 · Answer

@martinding  adding some extra screenshots to add clarity/ Formulas Comment 1 and Comment come after thiese

does this help?

martinding · Answer

Hi @wonka1234

Thanks for the sample data.

I noticed that in your original question, the expected output contained multiple Completed Date values in the Exception column, in the sample data, there's only a single column (and single row) "Comment" that contains the "Completed Date".

May I ask how the transpose was done? Was it like this?

Because in the Formula tool, what we are updating is the Comment 1 field, so it is not actually changing the values corresponding to the Tests. If we want to update OE Conclusion corresponding to Test 8 and 9, we'd have to write something like this:

wonka1234 · Answer

@martinding @binu_acs  There could be multiple values for a "test" in a row/record...  And some tests need a certain "comment" .