Forum Discussion

georgy's avatar
georgy
Frequent Visitor
7 years ago

TOTALYTD is not working

Hi,

TotalYTD function does not return the right value for me. I have DATE table which is linked to other tables.

I have the following data:

1. Sales Actual

2. Sales F-1 FY 20 Forecast 

3. Sales F-2 FY 20 Forecast

 

I created a measure Sales FSCT that uses Sales ACT and if Actual Sales are zero then Sales F-2 FY20 FCST is used. 

Then I added Sales YTD FCST = TOTALYTD(Sales FCST, Date, "31/03") but as you can see from photo it stops adding sales when Sales ACT is zero, even though Sales FCST measure shows the right numbers.

Can anyone help please.

Cheers