Expression simplifying

[#1]

Hi Community,

Is there any way to change the below expression in simple way

(sum({<DEST_COLUMN = {'F_1275223318_1954711793'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>} F_1275223318_1954711793)+

sum({<DEST_COLUMN = {'F_1275223318_408138104'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>}F_1275223318_408138104)+

sum({<DEST_COLUMN = {'F_1275223318_276776913'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>}F_1275223318_276776913)+

sum({<DEST_COLUMN = {'F_1275223318_92460603'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>}F_1275223318_92460603)+

sum({<DEST_COLUMN = {'F_1275223318_4129076935'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>}F_1275223318_4129076935))*REP_UNIT_FACTOR_A

[kaushiknsolanki]

Hi,

Not sure, but you can try this.

(sum({<DEST_COLUMN = {'F_1275223318_1954711793','F_1275223318_408138104','F_1275223318_276776913','F_1275223318_92460603','F_1275223318_4129076935'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>} F_1275223318_1954711793

+F_1275223318_408138104

+F_1275223318_276776913

+F_1275223318_92460603

+F_1275223318_4129076935

)*REP_UNIT_FACTOR_A

Regards,

Kaushik Solanki

[marcus_sommer]

It looks like that you have those fields within a crosstable in your datamodel - a change to a "normal" table could be helpful: The Crosstable Load

- Marcus

[#4]

values are not matching with original table

[kaushiknsolanki]

Hi,

could you please let us know, how is your data model look like.

Regards,

Kaushik Solanki

[#6]

pfa

[Kushal_Chawda]

try,

sum({<DEST_COLUMN = {'F_1275223318_1954711793','F_1275223318_408138104','F_1275223318_276776913','F_1275223318_92460603','F_1275223318_4129076935'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'},

RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>}  alt(F_1275223318_1954711793.0)

+alt(F_1275223318_408138104,0)

+alt(F_1275223318_276776913,0)

+alt(F_1275223318_92460603,0)

+alt(F_1275223318_4129076935,0)

)*REP_UNIT_FACTOR_A

[Anonymous]

Hi,

I  don't think that is possible summarize all "sum's" in just one "sum". But you can put the set analysys, which is common in all sum's (%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}) in a variable, to simplify the expression.

Best Regards