Subtotal Issue

[GDRIII]

I have an Adjustment History tale where a software bug created duplicate values under two different entry types. One is PLANT the other is TIN.

Normally I need to sum these two. No problem there. Problem is when the bug occurred the data is doubled until it was fixed.

To eliminate the dup values I wrote the measure [IF PLANT TIN]:=IF([PLANT]=[TIN], [PLANT],[PLANT]+[TIN])

Problem is my subtotal at the month level still show the inflated figure.

 

[mole999]

i don't know PP but have you refreshed the data source to normailise it

 

[scottsen]

There is almost enough info there to help, but I can't quite wrap my head around it. Can you share some sample data maybe?

I suspect some sort of "IsDupe" calculated column may be a better way?