--- title: Clarity PPM | Vary Resource Rates by Investment Type description: Vary resource rates by investment type in Clarity PPM (CA PPM). image: https://blog.regoconsulting.com/hubfs/Imported_Blog_Media/rego_guide_boy-97x300.png --- [![Rego-Logo_Notag-Color-350](https://blog.regoconsulting.com/hs-fs/hubfs/Rego%20Guide%20Images/Rego-Logo_Notag-Color-350.png?width=224&name=Rego-Logo_Notag-Color-350.png)](http://regoconsulting.com) - [Home](http://regoconsulting.com) [![](https://blog.regoconsulting.com/hubfs/Imported_Blog_Media/rego_guide_boy-97x300.png)](https://blog.regoconsulting.com/hubfs/Imported_Blog_Media/rego_guide_boy-97x300.png) # Clarity PPM | Vary Resource Rates by Investment Type ![rego_guide_boy](https://blog.regoconsulting.com/hs-fs/hubfs/Imported_Blog_Media/rego_guide_boy-97x300.png?width=97&height=300&name=rego_guide_boy-97x300.png) In today's Q&A, we'll guide you through the resolution of **five Clarity PPM (CA PPM)** issues we've seen crop up from time to time, like why you might get the "invalid relational operator" in GEL and how to handle a resource rate that varies by investment type. We also have a week's worth of new releases available from the regoXchange in our [Countdown to CA World 2016,](http://regoconsulting.com/countdown-ca-world/) including the deck for a **Resource Management Course** and free quick reference cards for **Accessing Resources** and **Creating Custom Filters,** Adding **Resource Skills,** Configuring the **Resource List,** and Managing **Resource Allocations.** [The whole list is here.](http://regoconsulting.com/countdown-ca-world/) You can find several additional free trainings and events, like a [half-day of Portfolio Management](http://regoconsulting.com/free-pm-and-jaspersoft-training/) help and [regoUniversity technical, functional, and governance training for Clarity PPM,](https://regouniversity.com/) at the bottom of this post. **Q&A Summary** 1. Why are my **Relational Operators** (in SQL inside GEL) invalid? 2. How can we set up the Rate Matrix to account for resources whose **rates vary by investment**? 3. How do you **Remove ETC** from an "Effort Task"? 4. Can we re-order **Input Controls**? 5. How do you get the **"Relative Date"** in an Input Control? Please feel free to comment on any alternative answers you've found in [the CA Community posting here.](https://communities.ca.com/docs/DOC-231171233)We love your input (always). > 1. I know this used to work, but I’m getting an “invalid relational operator” error in GEL when trying to do the simple query below using a "less than" sign. It’s inside CDATA tags. Version 14.3. Thoughts?? > >   SELECT prstart > FROM prtimeperiod > WHERE prestart <  (ADD\_MONTHS((LAST\_DAY(SYSDATE)+1),-1) - ?) > \]\]> > ${p\_close\_nbr} > ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ **Answer** Remember the **escapeText=”false”** > 2. We have a resource whose rate varies by investment. Is there a way to handle this in the Rate Matrix? We don’t have Investment as an option in the Default matrix. What config(s) should we change/update to get Investment included in the rate matrix? **Answer** Add investment in the rate matrix. Simply open the Rate Matrix and from the Assign Columns tab, select Investment > Add > Save.   > 3. A project is complete, so I want to remove ETC from an Assignment on an auto-created “Effort Task.” When I change the ETC to zero or just “delete” it, the ETC hours come right back. From what I’ve read through google searches, the ETC can’t be removed, but I refuse to believe this. Anyone know of a work around? We aren't using OWB/MSP, so those aren’t options. **Answer** It appears the only way to wipe out the allocation of the resource is from the Team tab. As soon as you do this, the ETC goes to 0. > 4. Is there a way to re-order Input Controls? **Answer** You can reorder via studio, if you click and drag. Sometimes it won’t allow you to re-order . . . however, if you restart and go directly to the repository and try again, it should fix itself and allow you to move them. > 5. Built in function in BO doesn’t appear to be in Jaspersoft. Curious if anyone has built the input control in JS and the logic in the query yet? **Answer** There is relative date. On the date it has a small tool tip saying if you put ‘WEEK’ it will get the relative date. Here are two articles you can also reference: [http://community.jaspersoft.com/wiki/how-change-start-day-week-relative-dates](http://community.jaspersoft.com/wiki/how-change-start-day-week-relative-dates) [http://community.jaspersoft.com/questions/803328/relative-dates-daterange-class](http://community.jaspersoft.com/questions/803328/relative-dates-daterange-class)   **THANK YOU------------------------------** A special thanks to David Zywiec, Ben Rimmasch, Ross Hensel, Michael Meyers, and the Rego Team for this Q/A material.   **Face-to-Face Clarity PPM Training** ![screen-shot-2016-10-27-at-5-52-51-pm](https://blog.regoconsulting.com/hs-fs/hubfs/Imported_Blog_Media/Screen-Shot-2016-10-27-at-5_52_51-PM-300x94.png?width=300&height=94&name=Screen-Shot-2016-10-27-at-5_52_51-PM-300x94.png) Our clients wanted us to create a forum for them to network with their peers, engage in debates and knowledge sharing, be taught best practices, and not feel like they were being sold something. In response to this, we created regoUniversity. Every year we gather the brightest minds in the Clarity PPM industry in one place with over 100 different companies represented. We learn together in interactive classes where the instructors and students share lessons learned and best practices based on experience. RegoUniversity 2017 will be held at La Cantera Resort & Spa - San Antonio, TX: April 23-27, 2017. Early bird pricing is available for a limited time. ### **Let Rego Be Your Guide** Join us live and in-person at [RegoUniversity in San Diego Sept 29-Oct 2 ](https://www.regouniversity.com/)and learn from the expert guides who deliver Clarity PPM and Agile services to 60% of Fortune 20 companies. Act now to save $300 on Early Bird Pricing until July 1st. Rego also offers [free health assessments](https://regoconsulting.com/ca-ppm-health-assessment/), [webinars,](https://regoconsulting.com/events-ca-ppm/) and [half-day training classes for Clarity PPM](https://regoconsulting.com/free-pm-and-jaspersoft-training/) on Roadmaps in the Modern UX, Power BI, Portfolio Management, and Jaspersoft.  For a full list of Clarity Services, visit [regoconsulting.com](http://regoconsulting.com/).  By [Camille Pack](https://blog.regoconsulting.com/author/camille-pack)|October 28, 2016 #### Share on Social Media - [Tweet](https://twitter.com/share) ### About the Author: [Camille Pack](https://blog.regoconsulting.com/author/camille-pack) ![Camille Pack](https://blog.regoconsulting.com/hubfs/profile%20camille200-2.jpg) 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 ![blog_4_necessities_for_a_pmo_charter_gartner](https://blog.regoconsulting.com/hubfs/Blog%20Images/2018/February/4%20necessities/blog_4_necessities_for_a_pmo_charter_gartner.png) [Permalink](https://blog.regoconsulting.com/4-necessities-pmo-charter) #### [Clarity PPM | Four Necessities for a PMO Charter](https://blog.regoconsulting.com/4-necessities-pmo-charter) February 28, 2019 | [0 Comments](https://blog.regoconsulting.com/4-necessities-pmo-charter#comments-listing) ![upgrading_Blog](https://blog.regoconsulting.com/hubfs/upgrading_Blog.jpg) [Permalink](https://blog.regoconsulting.com/whats-new-in-ca-ppm-clarity-15.5-modern-ux-features) #### [Clarity PPM | Should We Upgrade to 15.5? - Modern UX Features](https://blog.regoconsulting.com/whats-new-in-ca-ppm-clarity-15.5-modern-ux-features) November 05, 2018 | [0 Comments](https://blog.regoconsulting.com/whats-new-in-ca-ppm-clarity-15.5-modern-ux-features#comments-listing) ![regoU-Blog-changes_Linkedin_523x273](https://blog.regoconsulting.com/hubfs/regoU-Blog-changes_Linkedin_523x273.jpg) [Permalink](https://blog.regoconsulting.com/clarity-early-bird-special-register-by-january-31st-to-save-300) #### [Clarity PPM | Early Bird Special at RegoUniversity](https://blog.regoconsulting.com/clarity-early-bird-special-register-by-january-31st-to-save-300) January 24, 2018 | [0 Comments](https://blog.regoconsulting.com/clarity-early-bird-special-register-by-january-31st-to-save-300#comments-listing) ![](https://blog.regoconsulting.com/hubfs/Podcast-episode6-01.jpg) [Permalink](https://blog.regoconsulting.com/the-ppm-podcast-episode-6-davey-zywiec) #### [Clarity PPM | The PPM Podcast: Davey Zywiec on Reporting Strategies](https://blog.regoconsulting.com/the-ppm-podcast-episode-6-davey-zywiec) December 20, 2017 | [0 Comments](https://blog.regoconsulting.com/the-ppm-podcast-episode-6-davey-zywiec#comments-listing) ![](https://blog.regoconsulting.com/hubfs/regU-5-star-01.jpg) [Permalink](https://blog.regoconsulting.com/ca-ppm-clarity-event-is-a-5-star-experience) #### [Clarity PPM | 5 Reasons You Can't Miss This PPM Conference](https://blog.regoconsulting.com/ca-ppm-clarity-event-is-a-5-star-experience) November 21, 2017 | [0 Comments](https://blog.regoconsulting.com/ca-ppm-clarity-event-is-a-5-star-experience#comments-listing) ![](https://blog.regoconsulting.com/hubfs/15_3_blog_header-01.jpg) [Permalink](https://blog.regoconsulting.com/6-things-you-need-to-know-about-ca-ppm-15.3) #### [Clarity PPM | Six Things You Need to Know about 15.3](https://blog.regoconsulting.com/6-things-you-need-to-know-about-ca-ppm-15.3) October 24, 2017 | [0 Comments](https://blog.regoconsulting.com/6-things-you-need-to-know-about-ca-ppm-15.3#comments-listing) [![Rego Home](https://no-cache.hubspot.com/cta/default/2652075/655865ab-5c17-4a7d-8626-9917913749d3.png)](https://cta-redirect.hubspot.com/cta/redirect/2652075/655865ab-5c17-4a7d-8626-9917913749d3) [![Contact Us](https://no-cache.hubspot.com/cta/default/2652075/80445cd5-d730-4608-a09c-dcaaeff582b4.png)](https://cta-redirect.hubspot.com/cta/redirect/2652075/80445cd5-d730-4608-a09c-dcaaeff582b4) ### Subscribe to Email Updates [![Share on Facebook](https://static.hubspot.com/final/img/common/icons/social/facebook-24x24.png)](http://www.facebook.com/share.php?u=https%3A%2F%2Fblog.regoconsulting.com%2Fvary-resource-rates-by-investment-type-in-ca-ppm-clarity%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on LinkedIn](https://static.hubspot.com/final/img/common/icons/social/linkedin-24x24.png)](http://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.regoconsulting.com%2Fvary-resource-rates-by-investment-type-in-ca-ppm-clarity%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on Twitter](https://static.hubspot.com/final/img/common/icons/social/twitter-24x24.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.regoconsulting.com%2Fvary-resource-rates-by-investment-type-in-ca-ppm-clarity%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.regoconsulting.com%2Fvary-resource-rates-by-investment-type-in-ca-ppm-clarity%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=Clarity%20PPM%20%7C%C2%A0Vary%20Resource%20Rates%20by%20Investment%20Type) ### Recent Rego Articles ### Sign up for our Weekly Newsletter ![rego-logo-white](https://blog.regoconsulting.com/hs-fs/hubfs/rego-logo-white.png?width=205&name=rego-logo-white.png) 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/) ![](https://dc.ads.linkedin.com/collect/?pid=14053&fmt=gif)