Skip to main content
Question

IFS Report Designer conditional sum

  • March 3, 2022
  • 1 reply
  • 359 views
S
Do Gooder
Forum|alt.badge.img+9

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 replies.

1 reply

NickPorter
Superhero (Customer)
Forum|alt.badge.img+18
  • NickPorter
  • Superhero (Customer)
  • March 3, 2022

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 settingsAccessibility statement