I have 2 similar queries. They both have 2 structures, one is key fig and other is periods. They use same period structure, key fig structure is not same but very similar.
Requirement is, for spesific periods, i need a key figure to be 0 decimal, when for other periods it is 1 decimal. It is easy to apply:
-i ve changed decimal property of that period as 0 decimal,
-from advanced tab of that "periods" properties, eliminated formula collisiion, "use result of this formula"
I ve applied this in both queries: weird thing is, when it is working well in one, it is not working in other.Still showing 1 decimal, as changes have not been applied. I ve checked every single formula that can cause that difference between them, but no luck.
Also i ve tried to change the problematic cells via cell reference, and it worked. But i want to fix that without cell solution, can anyone recommend anything to check?
Thanks in advance,