String manipulation in text mode

Question

Hi there. I’m pulling a Proof Approvals report, where I am grouping by approverDecision to know what proofs are still pending and which ones have been reviewed/approved. It turns out that if a proof was set up as interactive, the system will lowercase the field value for approverDecision and will capitalize it if the proof was set up as static. See example screenshot:

I cannot find any string functions to use within valueexpression or something similar in text mode to normalize these fields. Any idea how to proceed here?

Current text mode grouping:

group.0.iscollapsed=truegroup.0.linkedname=approvergroup.0.namekey=view.relatedcolumngroup.0.namekeyargkey.0=approvergroup.0.namekeyargkey.1=namegroup.0.valuefield=approver:namegroup.0.valueformat=stringgroup.1.iscollapsed=truegroup.1.name=Approver Decisiongroup.1.valuefield=approverDecisiongroup.1.valueformat=stringtextmode=true

skyehansen · Accepted Answer

I would probably start by trying something like:

group.0.iscollapsed=true
group.0.linkedname=approver
group.0.namekey=view.relatedcolumn
group.0.namekeyargkey.0=approver
group.0.namekeyargkey.1=name
group.0.valuefield=approver:name
group.0.valueformat=string

group.1.iscollapsed=true
group.1.name=Approver Decision
group.1.valueexpression=UPPER({approverDecision})
group.1.valueformat=string

textmode=true

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded