Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

Aggregate issue

sum({<Is = {'N'},IsH = {'N'},[Date]= {">=$(vFrom)<=$(vTo)"},
[order Date]= {">=$(vGFrom)<=$(vGTo)"}> }[Cost])

 

I used Aggregate as below but getting error. i want to use aggr function because the total when exported in excel was not correct . Am i missing something from bellow expression 

 

sum(aggr({<Is = {'N'},IsH = {'N'},[Date]= {">=$(vFrom)<=$(vTo)"},
[order Date]= {">=$(vGFrom)<=$(vGTo)"}> }[Cost]))

2 Replies
Lisa_P
Employee
Employee

The aggr() function needs a field to aggregate by, this is missing in your example

everest226
Creator III
Creator III
Author

field is cost