Question

IFS Report Designer conditional sum

  • 3 March 2022
  • 1 reply
  • 219 views
S
Rank
Userlevel 3
Badge +8

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.

 

This topic has been closed for comments

1 reply

NickPorter
Rank
Userlevel 6
Badge +18

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