Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 BuminK
		
			BuminK
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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?
 
					
				
		
 marcus_sommer
		
			marcus_sommer
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
 
					
				
		
 marcus_sommer
		
			marcus_sommer
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
 BuminK
		
			BuminK
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I have changed the field Konto to mumeric then it worked
thanks
