topic Re: Field between two values in App Development

Field between two values

zied_ahmed1 — Tue, 04 Dec 2018 12:41:09 GMT

Hello ,

I have a field named Month_Time and i add Inline with numbers for every month

load * inline [

"Time Month", Month_ID

'Jan', 1

'Feb', 2

'Mar', 3

'Apr', 4

'May',5
'Jun',6
'Jul',7
'Aug',8
'Sep',9
'Oct',10
'Nov',11
'Dec',12

];

Now I have a field named Sales and i want if i select 3 or March I do the sum of sales the first 3 months I tried like that but it doesn't work

Sum({$<Month_ID={">=0<=$(max(month_ID))"}>} Sales)

Thanks for help

Anil_Babu_Samineni — Tue, 04 Dec 2018 12:43:56 GMT

How about this?

Sum({$<Month_ID={">=$(=Min({1} month_ID))<=$(max(month_ID))"}>} Sales)

zied_ahmed1 — Tue, 04 Dec 2018 12:46:00 GMT

Hello Thanks for your answer but it doesn't work

zied_ahmed1 — Tue, 04 Dec 2018 12:47:35 GMT

It select only the max value together

kjhertz — Tue, 04 Dec 2018 13:04:34 GMT

Try something like this:

Sum({$<[Time Month]=, Month_Id={"<=$(=max(Month_Id))"}>} Sales)

Anil_Babu_Samineni — Tue, 04 Dec 2018 13:17:21 GMT

What if [Time Month] is the Filter? Could be there is some problem in your month_ID field?

First try this in script to create field
Num(month(date#([Time Month],'MMM'))) as Month_ID

And expression is

Sum({$<Month_ID={"<=$(Max(Month_ID))"}>} Sales)