Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')))))
The problem was solved with a new logic.Thanks all
The problem was solved with a new logic.Thanks all