Requirement

[deepakqlikview_123]

Hi All,

I have data as per below

Month	Data
Jan	20
Feb	10
Mar	30
Apr	50
May	60
Jun	70
Jul	80
Aug	90
Sept	10
Oct	20
Nov	30
Dec	40

If user selects Feb then it will show Jan+Feb/2

If user selects Mar,Apr,May then it will show Feb+May/2

Can you please suggest.

Thanks

[richard_chilvers]

Hi

I'm not clear what your rules for the expression are.

For example, if the user selects Jul, Aug, Sep, what would the result be ?

[avinashelite]

Second part is not clear "If user selects Mar,Apr,May then it will show Feb+May/2" could you explain with an example i.e the output your excepting

[antoniotiman]

Hi,

try

Sum({<Month={'$(=Min(Month)-1)','$(=Max(Month))'}>} Data) /2

Regards

[deepakqlikview_123]

Hi,

For multiple month selection We need max( month) + Min (month) -1 .

Otherwise show max (month)+ max( month)-1 if selection is only one month

Thanks,

[avinashelite]

I think @antoniotiman‌has already given the solution , did you tried ??

[deepakqlikview_123]

Hi,

Thanks but this is not working

Thanks

[sunny_talwar]

Is month a text field or is it a dual field created using a date field?

[Anil_Babu_Samineni]

Is This is a Text field which you want to show the O/P

[deepakqlikview_123]

yeah it is text field