Welcome,
Guest



I am attempting to create a freeform condition that is supposed to be essentially "total debt most recent period as a percentage of the average total assets for the past four quarters is greater than the total debt in the same period one year ago (i.e. (TD MRQ / Avg TA) > (TD Q4 / Avg TA4)
I am getting an "invalid expression" error and I cannot figure out where my error is in the formula. Anyone have any ideas? Here is the formula I am trying to plug: ( Short Term/Current Portion of Long Term Debt(I) + Long Term Debt(I) ) / (( Total Assets(I) + Total Assets(I5)) / 2) > ( Short Term/Current Portion of Long Term Debt(I5) + Long Term Debt(I5) ) / (( Total Assets(I5) + Total Assets(I9) ) / 2) 
Alan


You need to separate your double parentheses with a space. The correct formula for your Free Form Condition is:
( Short Term/Current Portion of Long Term Debt(I) + Long Term Debt(I) ) / ( ( Total Assets(I) + Total Assets(I5) ) / 2 ) > ( Short Term/Current Portion of Long Term Debt(I5) + Long Term Debt(I5) ) / ( ( Total Assets(I5) + Total Assets(I9) ) / 2 ) You may want to use I4 instead of I5 on the left hand side of your condition, to capture the same quarter in the prior year (for quarterly reporting companies). Then the periods, also, would not overlap. 

