RE: Formula Help

[allyne]

Hello,

I have data that looks like the following

OrderID Lin1Resp(formula field) Line Ord Question

272 1 dog
272 2 yes
272 3 no

273 1 cat
773 2 dog
I Need a formula that will take the Line 1 ord Question and populate the Lin1resp field like the following. (there are many other fields and groupings in the report)


OrderID Lin1Resp(formula field) Line Ord Question

272 dog 1 dog
272 dog 2 yes
272 dog 3 no

273 cat 1 cat
773 cat 2 dog

Thanks for your help!

 

[CrystalizeCanada]

Assuming the report is sorted by OrderId this formula may be worth trying:

WhilePrintingRecords; //if the formula works without this line then it may be preferable to remove it
StringVar x;
if onfirstrecord or {MyTable.OrdId} <> previous({MyTable.OrdId}) then x := {MyTable.OrdQuestion} else x

Gordon BOCP
Crystalize