I have a table where there are some missing values. Logic to fill it up is by an average of previous and next. For this, i have created a calculated field that gets the previous value and next value using lookup and average it out.
Once missing data is filled i need to create a % change which will work as a table calculation field that i have created. But when i try to use the missing value calculated field inside %change calculation it gives an error saying table calculations can't be used in LOD.
any help on this would be greatly appriciated.
Thanks & Regards,
Rohan Fernando
Thanks so much.
I created a sample file. I'm trying to fill in missing values. For april i can have a calculated fieldwhich would be (PreviousValue() + Lookup(Avg(Price),1) /2 - something like that.
Then i need to create the %change field, where this would only be up to the level of sub category but i need to use a filter to enable only few codes (not to include all the available codes but the selected ones).
So i was thinking of fixing Category, SubCategory, codes, dates and getting the calculated missing value i have created above with isnull condition).
I'm struggling to get it over the line. Really appreciate any kind of direction on this. I have attached a sample file as well.
Thanks
