Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following Table
1 EB |
100 Stammkapital |
0143 immaterielle Vermögensgegenstände |
0520 Pkw |
0635 Betriebs- und Geschäftsausstattung |
0650 Büroeinrichtung |
0755 Gewinnvortrag vor Verwendung |
0850 Beteiligungen |
1000 Verrechnungskonto Anlagevermögen |
1010 Anlagevermögen |
1050 Beteiligungen |
1100 Verbindlichkeiten langfristig |
1200 Kunden gewerblich Inland |
1210 Kunden gewerblich EU |
1220 Kunden gewerblich Drittland |
4000 Kosten |
8000 Umsatz |
in a set analyses formula i want to select only all codes less than 4000 Kosten
Sum({$ <Jahr = {"$(=only(Jahr)-1)"}, Monat = {"*"}, Konto = {"< 4000"} >} [Betrag])
what is wrong with this formula?
It needs only a numeric field Konto to apply a <= >= comparison. Additionally helpful may also be to have further grouping-information to include/exclude areas.
It needs only a numeric field Konto to apply a <= >= comparison. Additionally helpful may also be to have further grouping-information to include/exclude areas.
I have changed the field Konto to mumeric then it worked
thanks