Year to Date with an if Expression

[#1]

Hello together,

i have a problem and search for the solution.

I want so show the the YTD figures, the column YTD works, but the YTD<150 doesen't works.

No of Orders	YTD	<150€	YTD <150
10	10	2	2
count([DISTINCT [Einkaufsbeleg])	count({year={$(vMaxYear)}, Date = {'<$(vMaxDate)'}, Month=>}[Einkaufsbeleg])	count(DISTINCT if((EffektivwertSumme>'150,00' AND EffektivwertSumme> '150') [Einkaufsbeleg]))	count({year={$(vMaxYear)},Date={'<$(vMaxDate)'}, Month=>} if((EffektivwertSumme>'150,00' AND EffektivwertSummer<'150), [Einkaufsbeleg]))

If you see the bold characters, there are problem with the if expression. How can include the if expression in the complete formula.

Thank you for you hints.

Greets Nikolaus80

[#2]

Effektivtry this should be EffektivwertSummer<'150'), you have missed a ' . I think

[alexandros17]

the syntax is wrong there must be a comma after condition

count(DISTINCT if((EffektivwertSumme>'150,00' AND EffektivwertSumme> '150') [Einkaufsbeleg]))

so

count(DISTINCT if((Cond>value1AND Cond>value2), 1,0))

hope it helps