i am appying the formula below in text in charge on a guage and it does not return any value, if i apply the same in pivot table i get a value. could someone please help as i need the value on the guage.
thanks
=if(DateParts.Quarter= 'Q4',(ceil(sum([Xerox.Order Fill % 2009]),0.01)))
