 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Unique ranking issue? [resolved] | Login/Join |
| Platinum Member |
I have a table with two numeric columns (A, B). Column B is a calculation on Column A (fixed amount - Col A). I want the report to display by highest A until B reaches zero, but, at minimum, I want to display 15 rows. In other words, if the value of Col B on the 5th row is zero, then I want to continue displaying rows until I have a total of 15 rows on the report. If Col B doesn't get to zero until the 30th row, then I want to display all 30 rows. Can this be done?This message has been edited. Last edited by: Ted Michalski, 7.7.02 Windows EXCEL, PDF, CSV, TEXT | ||
|
| Virtuoso |
Sure. You could compute an extra field in your table that keeps track of the record number (just increasing the value by one for every new record). And then have a second compute with which you define if the record should be printed or not using the newly created recordnumber and the value of the B column to decide. So something like this should do the trick: TABLE FILE ... COMPUTE RECNO/I5 = RECNO+1; NOPRINT COMPUTE PRINT/A1 = IF RECNO LE 15 THEN 'Y' ELSE IF COLB GE 0 THEN 'Y' ELSE 'N'; NOPRINT .... WHERE TOTAL PRINT EQ 'Y'; GamP
| |||||||||
| ||||||||||
| Platinum Member |
Thanks GamP. This works. 7.7.02 Windows EXCEL, PDF, CSV, TEXT | |||
|
| Platinum Member |
GamP, is there any way if the number of rows goes past 15 before I reach zero, to display all the rows that are not zero AND the first row that is zero? 7.7.02 Windows EXCEL, PDF, CSV, TEXT | |||
|
| Expert |
Ted, this is all to do with flagging records, then filtering. If you have the logic to flag the record, the you can keep it. For example: IF LAST COLB GT 0 AND COLB EQ 0 THEN 'Y' ELSE ... Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only Topic | View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |