Skip to Content
Former Member
May 21, 2010 at 08:00 AM

Decimal Conflict



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,