Calculation set analysis needed

[Rocky6]

Hi All,

I am working on some numbers and i need to calculate the following in the dashboard

(Count of items for dec21)- (count of items for nov 22) / (count of items for dec 21).

Can anyone help me out for  a set to calculate the above req. 

Thanks in advance 

[draghici1109]

Hello,

it would help to write here the dimensions and the kpi implied in this calculation. Also it is not clear from your description how exactly should the calculation take place. I am missing some parathesis "(" and ")".

Greetings

Alexandru

[Rocky6]

Hi Drahici,

Thanks for ur reply my aim is to calculate Clearance % YTD for a insurance. 

so i need this calculation .

(Count of items for for dec21)- (count of items for nov 22) / (count of items for dec 21).

dec21 should be static it should change based on every year. 

(i.e) present it should show  count of items for 22 December - count of items for 22 November and divide by the same count for dec 22.