This content has been marked as final. Show 2 replies
Go to your RPD Physical layer > change the Year column data type double into int then test it out. it should work
also u can try to use round function on the Dashboard prompt year column (edit prompt year column formula section add it)
example: Year data is 2010 then if u use round fxn
ROUND("MT BUSINESS DATE"."Year",0) this will give u 2010
ROUND("MT BUSINESS DATE"."Year",2) this will give u 2010.00
Have tried changing the datatype of Year column to INT?