Countback Days

[crumpm]

I have to write a formula to calculate countback days on a WiP balance, and wonder if anyone knows any shortcuts, as I have to go back 24 months, which involves huge repetitive formulas.


e.g.

if {#MFE WiP Bal) > {@Mth 1 Time} then
if {#MFE WiP Bal) > ({@Mth 1 Time}+{@Mth 2 Time} then
etc. up to 24 months

then
(({#MFE WiP Bal} - {Mth n Time})/(Mth 24 Days)*{@Mth 24 Days)

Any advice much appreciated.

Thanks

 

[Madawc]

If this is all for a single detail record, then I don't see a shortcut. You could make it a bit neater by defining some Formula Fields, e.g.

{@Mth 1 Time} + {@Mth 2 Time}

 @Back02 + {@Mth 3 Time}

And so on.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524. I doubt you can use them here but they often save a lot of time and effort.

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[crumpm]

Thanks for the tools advice. I will take a look at that.
And apologies for not mentioning version info.

I'm using CR 2008.

I will try the neatening formulas, as I think they will make it much easier to define.

Thanks