Display message per selection

[#1]

Hey guys,

From the table below the goal is to have sales every month for all the shops shown on the right. But if for example when selecting a shop in this case Hilltop 58 and there are months without any sales as in the case  of Mar, Jun, Oct and Dec, then a message should be displayed saying " There were no sales in the months of Mar, Jun, Oct and Dec for Hilltop 58".

Please any help on how to achieve these will be great.

Month              Sales

Jan                  € 2,500,25

Feb                  € 1,252,00

Mar

Apr                    € 500.25

May                  € 3,500,95

Jun

Jul                    € 4,652,85

Aug                    € 10,458,87                                          SHOPS

Sep                    € 15,896,45                                        Hilltop 58

Oct                                                                              T- Square 45

Nov                    € 25,875,65                                        Spring bell 38

Dec                                                                              Down beach 10

                                                                                    Coastal city 5

Thanks in advance.

[Digvijay_Singh]

Do you mean only when at least one month is present with no sales value?

[Digvijay_Singh]

I mean for the selected Shop

[#4]

Yes that is what I mean. In addition I also want to be able to display a message if I have months with Count of PaidWithTax greater than one.

[Digvijay_Singh · Accepted solution]

If yes, then - apply this condition in the show condition in layout tab of textbox -

len(Concat(distinct {1<Start_Month=E({$<Start_Month={"=sum(DISTINCT PaidWithTax)<>0"}>}Start_Month)>}Start_Month,',',Num(Start_Month)))>0

This is same concat statement we used in the main expression, we just picked that part and checking the length if it is greater than zero then only show the textbox.

[Digvijay_Singh]

Select GoodHotel to see the change

[Digvijay_Singh]

You mean a new separate textbox with some message if Count of PaidWithTax greater than one?

[#8]

Yes a new message text box if Count of PaidWithTax is greater than one.

[Digvijay_Singh]

Use something like this -

='There are ' & Count({$<Start_Month={"=sum(DISTINCT PaidWithTax)>1"}>}Start_Month) & ' Months with PaidWithTax >1'

Again use this count condition in layout show condition in case you want to hide it when count is zero.

Please mark correct, helpful answers in case my answers worked for you

Regards,

Digvijay Singh

[#10]

The PaidWithTax is for different products per Month

E.G

Star_Month         Product   PaidWithTax       Count

Jan                     TV          € 25,000               1

Jan                      DVD      € 1,500                 1

The result I am getting from the message states that there are two counts. But I only want it stating two counts if the column counts has the number 2 for example 2 TV PaidWithTax for Jan. Also please I would like to have the months displayed in the message as well. 

Thanks

[Digvijay_Singh]

Do you have column count already available with you?