Currently I am having redundant data for my script

[trishita]

For some reason I am having duplicate data for the same PensionCase Name which should vary with the manager name

My code looks like this:

If(Match([Pensionseinrichtung], 'HPF PPD'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPF PPD'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPF PPA'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPF PPA'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPF EK'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPF EK'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPK'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPK'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPR ALL'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPR ALL'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPR SMST'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPR SMST'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPR ZF'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPR ZF'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert])
, 'Unknown')))))

[agni_gold]

This is happening just because of your currency column in table , one is in USD and other is in EUR ,
if you looking for some other output so
can you send you sample app and required output.

[trishita · Accepted solution]

The problem was solved with a new logic.Thanks all