Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
values are not matching with original table
Hi,
could you please let us know, how is your data model look like.
Regards,
Kaushik Solanki
pfa
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
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