nothing

[ashish1504]

nothing

[vchuprina]

Hi,

Could you please show your current expression for KPI?

Regards,

Vitalii

[anat]

copy and paste same kpi and replace 01-01-2018  to 01-01-2022.

for date (01-01-2018),if u r using variables, change the variable logic 

[anat]

or else share the KPI logic.

[ashish1504]

sum ({$<Year={'$(vYear)'}, MonthNum={"=$(vMonth)"},Date=  , Entity={'PH'}, DISPLAY_FDV={1} >} COLUMN A /1000

[anat]

as per your logic ,u need to changes vYear variable logic.

[anat]

share vYear  logic,i will guide you what changes need to do

[vchuprina]

Try to add following to your expression

sum ({$<Year={'$(vYear)'}, MonthNum={"=$(vMonth)"},Date= , Entity={'PH'}, DISPLAY_FDV={1}, Date = {">01-01-2022"} >} COLUMN A /1000

[ashish1504]

Hi @vchuprina  It does not giving any result.

[vchuprina]

it's my example:

Date = {">01-01-2022"}

You should put your field here, value format should match with values in your field

[Your field]  = {">01-01-2022"}

Regads,

Viltaii