Closed
Column combine with condition in report definition
hi I have columns A ,B,C ,D with have stages comment for stage A,B,C,D and I would like to show the value base on another columns which have A ,B ,C D in the value. May i know how to do it?
***Edited by Moderator: Pooja Gadige to add capability tag***
To see attachments, please log in.
Posted: 2 years ago
JP Morgan Chase & Company
JP Morgan Chase & Company
US
hi Dharma! we have created 4 stages A,B,C,D and under each stage we have form to get user input for comment. And we save them separately into E,F,G,H variables. Now we would like to show the latest comment in a reports with a column call latest comment. And the value of this column will be based on current stage .For example , if we are at the stage A -> E comment should be shown in latest comment and if we are in stage B-> F comment should be shown.