YTD error in expression

[georgianamha]

Hi,

Can you please help me with your opinion, because i used the same formula in another app and worked just fine (obviously i use other field for filters)

Sum({1<product_name=$::product_name, product_category=$::product_category, product_code=$::product_code, customer_name=$::customer_name>} if(year(Data)=Year(Today())and DayNumberOfYear(Data) <= DayNumberOfYear(Today()),[Total sales RON]/4.95))

i tried also : sum (if(year(Data)=Year(Today())and DayNumberOfYear(Data) <= DayNumberOfYear(Today()),[Total sales RON]/4.95))

and i have same error

[Or]

It looks like [Total sales RON] is not recognized as a field or master measure, based on the coloring (it would be orange for a field and purple for a master measure). Perhaps this is your issue?