5
I am trying to hide Pay Rate for the COMM Pay Codes using Conditional Calculation fields for the Pay Rate in the DD Earning Statement RW Report..
To be able to have 0.00 PayRate and then to hide it I added expression:
uprWorkChkDesc.Pay Code Array[1]=COMM
True: 0.00
False: uprWorkChkPayRate Array[1]
Although the Pay Rate prints for this Pay Code still. What should I change to to make the result equal to 0.00 ? Should I use any other array field in the expression?
Thanks,
Vivian
Hi Brandon,
I am aware of the arrays and I have added 12 Arrays fields. I used Payroll Check Description Field for the Pay Code field that appears there while I do not find it in the Payroll Work Check Table. I do have a feeling that I have to try another field but I don't find which one because Pay Rate is based on the Pay Code that is available in the Check Description Table. Here is in my Conditional Calculated field. It is pretty simple but RW does not react to any condition even both zeros for both cases True and False. What field should I try instead of the uprWorkChkDesc.Pay Code Array?
uprWorkChkDesc.Pay Code Array[1]=COMM
True: 0.00
False: uprWorkChkPayRate Array[1]
Thanks,
Vivian
In my opinion you need some dexterity code to fulfil this requirement.
Hey Vivian,
Thank you for your response.
These reports that use arrays can be tough to modify.
Moving forward, what if you use the Payment Work Check Table for your initial expression like the TRUE case is using. The original Arrays are all off the Payroll Work Check Table. You are currently using the Payroll Check Description table.
If that does not work, can you provide a screenshot of your calculated field as well as a screenshot of how the report looks?
It might be faster to create a support case if this is urgent so an engineer can focus on this.
I hope this helps!
Thank you!
Hi Brandon,
I tested the report and empty value does not work for my calculated conditional field, it should be the value in True Case and False Case. True case should be Currency Value: 0.00. Although something does not work for this report and it shows Pay Rate for the Pay Code notwithstanding.
Hey Vivian,
Thank you for your forum question.
One thought i have is, what if you set the true case to be blank. Then you can set the field to hide when it prints blank in the Report Field Options window for your calculated field.
I hope this helps!
Thank you!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,554
Super User 2024 Season 2
#2
Martin Dráb
228,588
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (