Question on periodOverPeriodDifference

I am using periodOverPeriodDifference(sum({MRR}) as My calculated field but the issue here is.

I need to Calculate the Expansion and Contraction MRR of my customers

Lets say if name of the above calculated field is MoM-Value

Name Jan Feb March
A 0 10 20
B 0 10 10
C 0 20 10

Expansion should be
JAN FEB MARCH

ALL 0 40 20

Contraction should be

 JAN FEB MARCH

ALL 0 0 20

But my results is

 JAN FEB MARCH

ALL 0 0 0

I tried to create a boolean column with MoM-Value > 0 but due to this aggregation, This is not working as expected

are all of your date fields grouped to the month?

Did you use the month period as well?

Finally can you tell me how contraction is 20 on march because it seems like the totals are 0,40,40.

So it should be 0,40,0 for expansion and 0,0,0 for contraction

1 Like

@Max Yes I used that is results I mentioned above.

I need expansion as
JAN FEB MARCH
A 0 10 10
B 0 10 0
C 0 20 0

ALL 0 40 10

I need like this But If we are using the that function

@Max Can we pass any condition here (Any TRUE/FALSE)

@Sanjay-dev-ds

You mean like this?

ifelse(periodOverPeriodLastValue(distinct_count(({client_id[users]})),{arrival_timestamp},MONTH,-1)<0,'contract','expansion')