How to incorporate date field in this current scrip

[trishita]

if (Match([Pensionseinrichtung],'HPK'), sum( total {$<Pensionseinrichtung={'HPK'}>} [HPV Buchwert]),

if (Match([Pensionseinrichtung],'HPR ALL'), sum( total {$<Pensionseinrichtung={'HPR ALL'}>} [HPV Buchwert]),

if (Match([Pensionseinrichtung],'HPR SMST'), sum( total {$<Pensionseinrichtung={'HPR SMST'}>} [HPV Buchwert]),

if (Match([Pensionseinrichtung],'HPR ZF'), sum( total {$<Pensionseinrichtung={'HPR ZF'}>} [HPV Buchwert]),'Unknown'

))))

I want to add a condition for a specific date given by the field Stichtag = 'Dez.2018'. How to incorporate this date field in this current script

[sunny_talwar · Accepted solution]

May be this

If(Match([Pensionseinrichtung], 'HPK'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPK'}, Stichtag = {'Dez.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPR ALL'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPR ALL'}, Stichtag = {'Dez.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPR SMST'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPR SMST'}, Stichtag = {'Dez.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPR ZF'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPR ZF'}, Stichtag = {'Dez.2018'}>} [HPV Buchwert])
, 'Unknown'))))

[trishita]

Thanks