Writing the long repetitive formula

building reports webintelligence
1

When writing the long repetitive formula, Can we just copy/paste it rather than typing the same parts multiple times ?

Mr. XI (BOB member since 2008-09-25)

2

Sure. You could have tried it to see and answered the question yourself. :slight_smile: I often will get the first part of the formula done, then copy the initial portion into Notepad or other text edit. I complete my work there and then copy the final result back to Webi.

Dave Rathbun :us: (BOB member since 2002-06-06)

3

Yea that’s what I always do as well Dave.

The variable editor in Webi is such a pain, its much easier to write it in notepad.

foxy :uk: (BOB member since 2007-10-22)

4

Yes, Dave’s practice is a good method due to the teeny-tiny screen we get to work with in WebI (why can’t it be like working in Designer?). One thing to point out is when working in something like notepad, we like to use a “hard return” on stuff (esp “if” clauses to see the conditions singularly). After you are satisfied with the way it looks in notepad, you then need to turn wordwrap off and go to the end of your first line and hit the “del” key to remove that hard return, and subsquently to every other line so that you get one continuous statement without hard-returns (wrap in notepad is ok). Once you’re done the “remove the hard return” routine, you can copy/paste back to the menu screen and move forward.

Thanks,
John

jsanzone :us: (BOB member since 2006-09-12)