I screenshot i m calculating percentage difference of DPPM based on month -1 with partition error trend, for partition error trend where DPMO is blank in current month and not blank in month -1 should show as -100 as percentage difference, while doing calculated field its not giving me the % differenxce,
Tried calculated field as (ifelse (isnull(SUM(DPMO)) and isnull(improvement %),-1, improvement %)) , its not gieving any error and also not giving any value in imrrovement field where DPMO is blank
ce as 100 and its coming blank
Hi, @mjdhav. Thanks for your question. I have reached out to a few people from our team to get you a reply.
Hi mjdhav,
Are you trying to show MoM percentage difference for DPPM using periodOverPeriodPercentDifference() function, if not then can you write your calculation here that you are using for DPPM?
1 Like
@imaitri I Am calculatin g imrpovement % as percentDifference(sum(DPMO1),[YYYYMM ASC],
-1,[description]
)
Hi @mjdhav -
If null
always equates to 0
in your business logic, the 2nd approach you described should work.
ifelse(isnull({c_pop}),-1,{c_pop})
If it doesn’t, please share the data source you are using.
1 Like