---
title: "Clarity PPM | Learn with Rego: Override Project Status + More"
description: Learn how to make the most out of your Clarity PPM (CA PPM) investment with Rego. Override project statuses and more.
---
[](http://regoconsulting.com)
- [Home](http://regoconsulting.com)
# Clarity PPM | Learn with Rego: Override Project Status + More
Dear Community Members,
In this week's *Learn PPM with Rego*, we'll explore five Clarity PPM (CA PPM) questions and answers.
1. How do you **override **the **Project Overall Status **Report values?
2. Gel Process Writing | When writing a CSV file, how can we **make it blank instead of displaying null?**
3. Where is this **strange date **coming from in our Calendar Table?
4. Is the **vendor code **tracked when we post a contractor's timesheets?
5. Can you help us with the **delimiters **in our Gel Script?
Please feel free to comment on any alternative answers you've found [within the CA Community here.](https://communities.ca.com/docs/DOC-231169192)
We love your input (always).
**------------------------------**
**1 **
Is there a way to override the value that shows the Overall status as "Red/Yellow/Green," so that when the Schedule is "RED" the Overall Status will show as "RED," without considering the values in Scope and Cost?
We want this override anywhere the “Triple Constraint” (Schedule/Cost/Scope) is used, so whenever Schedule is RED, Overall STATUS is RED.
**Answer**
Change the weighting factor in the calculation so that the Schedule Status has a higher weight and forces a project to show as red if it's behind schedule.
**------------------------------**
**2**
When writing a CSV file, how can we make it blank instead of displaying null?
**Answer**
In the query, we used ***NVL(TO\_CHAR(INVID),'null') INVID*** to make sure all numbers were first characters. Then we made them 'null' as a true string (instead of GEL adding it later). Finally, the column write looked like this:
******
**------------------------------**
**3**
We have a portlet that queries against the nbi\_dim\_calendar\_time table. Why does a 1950's date show up occasionally in the data?
**Answer**
Odds are good that there is something in the system extending back to 1950, whether accidentally or intentionally. The ***NBI\_DIM\_CALENDAR\_TIME*** table is populated by the stored procedure ***NBI\_POPULATE\_CAL\_DIM\_SP*** which is used by the Datamart Extraction job.
When that job runs for the time within the ***NBI\_DIM\_CALENDAR*** table (two-years-worth of calendar structures: weeks, month, quarter, etc), subsequent runs of the job will ensure the creation of enough calendar periods to cover the extension of Clarity PPM's data curves. These data curves include information such as allocation, availability, and actuals.
If any object exists in the system with 1950 curve data attached, you'll probably see the date.
**------------------------------**
**4**
Is the vendor code tracked when a contractor's timesheet posts to the financial tables? The contractor is associated with the vendor.
Note: We realize the vendor is in the APINFO table, which holds the voucher header info for manual and (usually) non-labor transactions, but what's the expected behavior for labor transactions via timesheets?
**Answer**
The vendor code is not tracked in the WIP tables along with the transaction details. You'll have to pull the current value from the resource record.
**------------------------------**
**5**
Is there a limit on what delimiters can be used when reading a file using GEL? We're trying to specify pipe as a delimiter (i.e., delimiter="|"), and it's not working. We don't want to use comma (,) because there are commas in the data.
**Answer**
You can escape the pipe character with a "**\\**". As below:
******
## ------------------------------
\*A special thanks to the brilliant [Navdeep Joshi](https://in.linkedin.com/in/navdeep-joshi-pmp-capm-389a8a9) and the Rego Team for this great material.
[This article is published on the CA Community site. Join the conversation here.](https://communities.ca.com/docs/DOC-231169192)
By [Camille Pack](https://blog.regoconsulting.com/author/camille-pack)|August 05, 2016
#### Share on Social Media
- [Tweet](https://twitter.com/share)
### About the Author: [Camille Pack](https://blog.regoconsulting.com/author/camille-pack)
Camille Pack has been in marketing for over a decade and started her career as a college composition instructor during graduate school. Technical writing lends itself well to mastery, and in her time at Rego, Camille offered clients product support, configured environments, and served as both a project manager for an internal reporting group and a business analyst for a large external client. Camille holds an MA in Literature and Writing, and a BS in Biology.
### Related Posts
#### [Clarity PPM | Resolving Issues with Jaspersoft Scheduled Reports](https://blog.regoconsulting.com/resolving-issues-jaspersoft-scheduled-reports)
October 14, 2016 | [0 Comments](https://blog.regoconsulting.com/resolving-issues-jaspersoft-scheduled-reports#comments-listing)
[Permalink](https://blog.regoconsulting.com/learn-ppm-rego-open-workbench-series-part-1)
#### [Clarity PPM | Learn PPM with Rego: Open Workbench Series - Part I](https://blog.regoconsulting.com/learn-ppm-rego-open-workbench-series-part-1)
August 26, 2016 | [0 Comments](https://blog.regoconsulting.com/learn-ppm-rego-open-workbench-series-part-1#comments-listing)
[Permalink](https://blog.regoconsulting.com/learn-ppm-with-rego-escalate-risks-and-issues-to-the-program-level-more)
#### [Clarity PPM | Learn with Rego: Escalate Risks and Issues to the Program Level + More](https://blog.regoconsulting.com/learn-ppm-with-rego-escalate-risks-and-issues-to-the-program-level-more)
July 29, 2016 | [0 Comments](https://blog.regoconsulting.com/learn-ppm-with-rego-escalate-risks-and-issues-to-the-program-level-more#comments-listing)
[Permalink](https://blog.regoconsulting.com/jaspersoft-trick-masterful-dashboards)
#### [Clarity PPM | 5-Minute Jaspersoft Dashboards](https://blog.regoconsulting.com/jaspersoft-trick-masterful-dashboards)
March 14, 2016 | [0 Comments](https://blog.regoconsulting.com/jaspersoft-trick-masterful-dashboards#comments-listing)
[](https://cta-redirect.hubspot.com/cta/redirect/2652075/655865ab-5c17-4a7d-8626-9917913749d3)
[](https://cta-redirect.hubspot.com/cta/redirect/2652075/80445cd5-d730-4608-a09c-dcaaeff582b4)
### Subscribe to Email Updates
[](http://www.facebook.com/share.php?u=https%3A%2F%2Fblog.regoconsulting.com%2Flearn-ca-ppm-with-rego-override-project-status-blank-instead-of-null-strange-date-vendor-code-tracking-delimiters%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [](http://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.regoconsulting.com%2Flearn-ca-ppm-with-rego-override-project-status-blank-instead-of-null-strange-date-vendor-code-tracking-delimiters%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.regoconsulting.com%2Flearn-ca-ppm-with-rego-override-project-status-blank-instead-of-null-strange-date-vendor-code-tracking-delimiters%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.regoconsulting.com%2Flearn-ca-ppm-with-rego-override-project-status-blank-instead-of-null-strange-date-vendor-code-tracking-delimiters%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=Clarity%20PPM%20%7C%C2%A0Learn%20with%20Rego%3A%20Override%20Project%20Status%20%2B%20More)
### Recent Rego Articles
### Sign up for our Weekly Newsletter
As the leading PPM, Work Management, and Agile services provider, we have helped hundreds of organizations achieve a higher return on their software investment.
### CONTACT US
Questions? We can help.
[info@regoconsulting.com](mailto:info@regoconsulting.com)
888.813.0444
### Stay up-to-date
Get the latest news in industry best practices, thought leadership, and software updates.
### Solution Capabilities
[Clarity PPM](https://regoconsulting.com/clarity-ppm/)
[Rally](https://regoconsulting.com/rally/)
[Apptio](https://regoconsulting.com/apptio/)
[Sciforma](https://regoconsulting.com/sciforma/)
[Jira](https://regoconsulting.com/jira/)
[Microsoft | SharePoint](https://regoconsulting.com/microsoft/)
[Smartsheet](https://regoconsulting.com/smartsheet/)
[Meisterplan](https://regoconsulting.com/meisterplan-itdesign/)
### Quick Links
[Our Company](https://regoconsulting.com/our-company/)
[RegoUniversity](https://www.regouniversity.com/)
[RegoXchange](http://regoxchange.com/)
[Careers](https://regoconsulting.com/careers/)
Copyright 2022 Rego Consulting Corporation
[Linkedin](https://www.linkedin.com/company/rego-consulting?trk=biz-companies-cym)[Facebook](https://www.facebook.com/RegoConsulting/)[Youtube](https://www.youtube.com/channel/UCdA5xEiDrX--y2nVX2wC1UA?view_as=public)[Twitter](https://twitter.com/regoconsulting)
[Privacy Policy](https://regoconsulting.com/privacy-policy/)
