Space in aggregation function

[jeevays7]

Hi frds,

I have a result table like this.

Table1:

Name          Gross          Net

A               50               40

B               50               30

C               40               20

The expression of Net column is:

Num(sum(aggr(Sum({$<CAPITAL_FLOW_TRANSACTION_DATE= {"$(vDateMax)"}>} EXPOSURE ),SEC_ID,EXT_ID))

/

Sum(Total {$<CAPITAL_FLOW_TRANSACTION_DATE=  {"$(vDateMax)"}, $(=vNullify)>} CLOSING_CAPITAL )

,'$#,##0').

If i make a space in the above expression at Before SEC_ID in aggregation like below,

Num(sum(aggr(Sum({$<CAPITAL_FLOW_TRANSACTION_DATE= {"$(vDateMax)"}>} EXPOSURE ), SEC_ID,EXT_ID))

/

Sum(Total {$<CAPITAL_FLOW_TRANSACTION_DATE=  {"$(vDateMax)"}, $(=vNullify)>} CLOSING_CAPITAL )

,'$#,##0').

The result is changed like this.

Result with Space in aggregation:

Name          Gross          Net

A               30               30

B               50               30

C               40               20

-                20               10

why?

and the above table with space in aggregation, if i check suppress null value, it is displayed correctly as Table1. but when we publish the document in browser the result is not correct. it looks like below,

Result with Space in aggregation and suppress null and published in browser:

Name          Gross          Net

A               30               30

B               50               30

C               40               20

why?

[sunny_talwar]

Would you be able to share your app to show the issue (or a sample where this issue is present)?

[jeevays7]

Hi sunny,

Thanks for your reply. that is a big app sunny. cant able to upload

[sunny_talwar]

See if this helps:

Preparing examples for Upload - Reduction and Data Scrambling