Fletch Posted September 12, 2016 Share Posted September 12, 2016 I have a sequential numbering rule that's counting from 1 to 300,000. I also need to create a rule that will print the number '1' during the first 10,000, number '2' during the second 10,000...and so on. Is there an easier way to accomplish this than creating a Drag n Drop rule with 30 'IF Greater than and Less than' components? Just wondering. Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted September 12, 2016 Share Posted September 12, 2016 return Int((FusionPro.Composition.outputRecordNumber - 1) / 10000) + 1; Quote Link to comment Share on other sites More sharing options...
Fletch Posted September 12, 2016 Author Share Posted September 12, 2016 I copied and pasted that into an empty rule. no matter which record I go to, the number is always a '1'. Quote Link to comment Share on other sites More sharing options...
Fletch Posted September 12, 2016 Author Share Posted September 12, 2016 Well, this is weird. The Rule looks to work when the rule is opened. The Building Blocks and Validate show that it works. However, when I place that rule in a text box it gives me '1' on every record. Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted September 12, 2016 Share Posted September 12, 2016 Depending on how the job is set up to do the numbers, you might need to put something else in there instead of FusionPro.Composition.outputRecordNumber; maybe FusionPro.Composition.processedRecordNumber or FusionPro.Composition.inputRecordNumber. I would make the rule simply return FusionPro.Composition.outputRecordNumber and see what you get from that. Quote Link to comment Share on other sites More sharing options...
Fletch Posted September 12, 2016 Author Share Posted September 12, 2016 The third one worked. (FusionPro.Composition.inputRecordNumber) Thanks a million. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.