Forum Discussion

dmoney7612's avatar
dmoney7612
Icon for Helper II rankHelper II
5 years ago

Help needed with sales formula

I'm looking to create a projected sales formula for the remainder of the fiscal year. I have 2 measures: YTD sales and YTD sell days. The formula divides the YTD Sales by the YTD sell days and then m...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I typically change the data and provide similiar, but fake data. For example, I have specific customers where I work and instead of using them I just use fake ones like Apple, Microsoft, etc. 

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

There may be a lack of context.

Try to use complete formulas to replace measures [FYTD 22 Sales (Ex Flu)] and [FYTD22 Sell Days] .

 

Best Regards,
Community Support Team _ Eason