Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help with estimating

Hello   I have a simple file which is based on a regulatory returns a company submits to a regulatory body.  The company submits this file at the end of each financial year and the revenue amongst ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
So what is your formula for calculating estimated revenue? Average of the previous years? maximum, minimum?
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Greg

 

Apologies for not mentioning in the original post.  It's just basically the revenue from the previous financial year.

 

Thanks for your help

 

Jo

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    I would use an Enter Data query to enter your estimates. Then you could use UNION to union the two tables together and perform operations on them.