|
Hi, I use a report which provides people with intervals for doing a particular task, in this case removing production samples.
I have a @sample_size formula which returns the number of samples that are to be taken.
I then have @job_quantity which returns the number of items in total.
I am after returning the figures when I need to take a sample out,
i.e
i@job_quantity = 120
@sample_size = 10
this would be 1 sample every 12
so I want to return 1, 12, 24, 36, 48, 60, 72 ... and so on.
currently I have a separate formula for each figure then placed into a text box with a comma added using the currency symbol option, however I now need to return unto 250 samples and don't wish to write a formula for each and then have to format each one!
Any help is appreciated.
|