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]

GetSelectedCount(Shop)>=1 and Aggr(Count(DISTINCT{<Abonnement = {'DM-CFV','DM-CFB','DM-E&F','CFB','DM-E&A'},InvoiceTypeID = {2}>}PaidWithTax),Start_Month,Product,shop)>1

[#3]

Hi Digvijay,

It worked. Thank you so much. You have been very helpful I really appreciate that.Once again thanks.

[Digvijay_Singh]

I am glad I could help you. You can mark more than one helpful answers if you feel so.

[#5]

Yeah sure, thanks again

[#6]

Hi Digvijay,

Please I need your help with these tabel below.

MeterNo          Volume1              Volume2            Consumption     Actual consumption

12030001          5,306                  10,235                4,929                    -              

12030002          8,650                    12,965               4,315                   -

12030003          3,458                    8,697                 5,239                   5,853

Here the consumption is just volume2 - volume1. So my main problem is getting the actual consumption like i have it display in the table. That is " 4,929  + 5,239 - 4,315 = 5,853. But I don't know how to get that done on a straight table. Please help me out.

Thanks

[Digvijay_Singh]

You have added first and third consumption value and subtracted the 2nd one but I am not sure why you did it, if you could explain the logic, we can develop the formula to be applicable for all cases.

[Digvijay_Singh]

For this sample, it can be like as below but may not work in real situation as I am not sure of logic yet for actual consumption -

[#9]

The meterNo 12030002 is the meter that control the lighting in the hall way of the apartment blocks so that amount needs to be subtracted to get what the customers actually consume.So that is why I am subtracting the value.

[#10]

Thanks for your help Digvijay

[Digvijay_Singh]

U r always welcome.

Regards,

Digvijay