Samantha,
I'm not too keen on DeskI formulas as I usually work in a WebI environment, but an observation in using BusinessObjects tools seems to come up frequently when doing math computations is the need to use a decimal point within a value in order to get more consistent results. I notice in your formula that you are taking a date and multiplying (24 * 60)/1440, but if you could work it as (24.0 * 60.0)/1440.0) or you may even need to do something like 1.0((2460)/1440). The point is in trying to put decimal values (or introduce a decimal value to the formula) and in doing so you will invoke floating point operations and in turn perhaps get more consistent results. Just a shot in the dark to you as a suggestion....
Thanks,
John
Add comment