Hello Workfront Community, I am running into an issue with a calculated column expression that I am trying to implement in a project report. Text mode included below.
displayname=Web Revenue on Project
linkedname=direct
namekey=fixedRevenue
querysort=fixedRevenue
textmode=true
valueexpression=IF({templateID}=5cf68aa5013d07e39626464fe1bf4ae8, PROD({fixedRevenue},0.85), IF({templateID}=560e8e40003a475314e84bf86b75a3e7,{fixedRevenue}, IF({templateID}=5c193194000fb4d68dce3bbf473728db, PROD({fixedRevenue},0.6),{fixedRevenue})))
valueformat=currencyStringCurrencyRounded
The part that I need help with is the "valueexpression=" line. I am trying to create a nested IF statement that will look at the project's template ID, if it matches one of the values listed that I would like the column to perform the PROD function multiplying fixedRevenue by the value of 0.85, 0.6 or just return the full fixedRevenue value. I believe the issue may be in the way I am referencing "templateID" in this expression. Since this is a calculated column does it need to be "{template}.{ID} since template information is a reference element within Project according the API explorer? This is all very confusing since the formatting of these text mode codes varies slightly depending on where they are being developed. Any help is much appreciated!! Cameron Howitt
