Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I'm trying to get the correct results for an expression that should:
I already tried the following:
Can't solve this, hopefully someone has the solution to this.
Thank you
Try:
Edit: Corrected -removed '$'
can you post a sample application and expected output?
Still not working, thank you though
LOAD * INLINE [
Data, Cod, X, Amount
14/11/2017, 000001, 3, 1000
14/11/2017, 000002, 6, 5000
14/11/2017, 000003, 7, 8000
14/11/2017, 000004, 2, 750
15/11/2017, 000001, 3, 1200
15/11/2017, 000002, 6, 6000
15/11/2017, 000003, 7, 7500
15/11/2017, 000004, 2, 1000
];
What I'm trying to get is a table with the sum of "Amount" for each Cod whose avg(X) is between 5 and 10
Cod | AvgX | AmountSum
000002 | 6 | 11.000
000003 | 7 | 15.500
Try like this
Sum({<Cod={"=Avg(X)>=5 and Avg(X)<=10"}>}Amount)
PFA
Yes, seems like the expansion sign $ was the culprit. Thank you!