Projected Year End

[Pomna]

Hello experts am supposed to create a gauge showing  revenue projected year end given the revenue, forecast YTD, MTD. I would appreciate your help.

Thanks

[dplr-rn]

Need much more details i am afraid.
share a sample of your data or a sample app