nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Displaying a date value in one column based on a value within another column

andyeali

Good Day,
 
I would like to display a date value within a date column that is based on the value of another column. It's an inventory based report. The transaction date should match the transaction type. Also, I would like to use the transaction date and the transaction type twice. This will allow the user to view the transaction date that matches a specific transaction type.
 
I hope this makes sense to someone.
 
Regards,
Andy
 
NB
See attachment for snapshot of layout.

Find more posts tagged with

Comments

Clement Wong

Sorry, it doesn't make sense to me. Can you provide sample data so that I can understand the requirements?

andyeali

Mr. Wong,
 
I hope all is well today.
 
I attached an MS Excel file containing a sample layout of the current report as well as the proposed change I would like to implement with a further explanation.
 
Regards,
Andy

shamo

You can create a computed column one for _PC and one for _Rec and use both in the report.

andyeali

Shamo,
 
I hope all is well with you today.
 
I appreciate the feedback. Can you explain further or provide some guidance as to where I can find some reference material.
 
Much appreciated.
 
Regards,
Andy

pricher

Hi Andy,
 
You need to create 2 Computed Columns in your Data Set, one for TRANSTYPE_PC and one for TRANSTYPE_REC. The expression for each computed column will test the value of TRANSTYPE and output or not the value of TRANSTYPE. The following screenshots show the process: