Skip to main content

Hi,

I have a column (COMPANY_NAME) which should show a value based on state. If state of the line is ‘Approved’, then attribute BH_VAL will be shown, otherwise attribute CF_EXT_EXPECTED (custom field) will be shown (red arrow).

Yellow highlight field should show the sum of COMPANY_NAME VALUE.

As COMPANY_NAME either have  BH_VAL or CF_EXT_EXPECTED, how can I get the SUM of  COMPANY_NAME?

Appreciate the response.

Thanks.

 

As a workaround could you change it to simply query the data again for a count of COMPANY_NAME records that would be in the report?  i.e. pull that count from the source data instead of doing a SUM of the data shown in the report?

Nick

Terms & ConditionsCookie settings