Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Effektivtry this should be EffektivwertSummer<'150'), you have missed a ' . I think
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