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.

[#2]

It worked,'

Thanks very much.

[#3]

Hi Digvijay,

I have the above display as an alert to deliver as email. So, I will like to have the information aligned. As you can see its not and I have been trying to use different numbers in the Repeat function but its not given me the desired result. Please help me out. Here is the expression I used.

='< 10% elektra data difference for these Connections for 2015 -

'& chr(10)&

'Organisatie'&Repeat(' ',10)&'Locatie'&Repeat('  ',10)&'EANCode'&Repeat(' ',10)&'Jaar'&Repeat(' ',10)&'Eventstanden'&Repeat(' ',10)&'S. J. V'&Repeat(' ',10)&'%' &chr(10)&

concat(aggr(if((sum({<Year = {2015},DataTypeID = {5},EnergyTypeID = {53},QualityScore = {">0"}>}Volume1 + Volume2)

-

sum({<Year = {2015},DataTypeID = {45},EnergyTypeID = {53},QualityScore = {">0"}>}Volume1 + Volume2))/

(sum({<Year = {2015},DataTypeID = {45},EnergyTypeID = {53},QualityScore = {">0"}>}Volume1 + Volume2)

+ sum({<Year = {2015},DataTypeID = {5},EnergyTypeID = {53},QualityScore = {">0"}>}Volume1 + Volume2))*100> 0.10*100,

//new lines

if (sum({<Year = {2015},DataTypeID = {45},EnergyTypeID = {53},QualityScore = {">0"}>}Volume1 + Volume2)>0,

Only(Nameoforg) & ':' & '     '&Only(StreetName) & ':'& '     '&Only(EANCode) & ':'&'     '&Only(Year) & ':'&

  right('          ' & num(sum({<Year = {2015},DataTypeID = {45},EnergyTypeID = {53},QualityScore = {">0"}>}Volume1 + Volume2), '#,##0'),10) &

  '      ' & num((sum({<Year = {2015},DataTypeID = {5},EnergyTypeID = {53},QualityScore = {">0"}>}Volume1 + Volume2)), '#,##0')&

  '      '& num((sum({<Year = {2015},DataTypeID = {45},EnergyTypeID = {53},QualityScore = {">0"},Volume1 = {">0"}>}Volume1 + Volume2)

-

sum({<Year = {2015},DataTypeID = {5},EnergyTypeID = {53},QualityScore = {">0"},Volume1 = {">0"}>}Volume1 + Volume2))/

(sum({<Year = {2015},DataTypeID = {5},EnergyTypeID = {53},QualityScore = {">0"},Volume1 = {">0"}>}Volume1 + Volume2)),'##0%')

  ,null())

//end of newly added condition

)

     , Nameoforg,StreetName,EANCode,Year), '

', Month * +1)

Thanks.

[Digvijay_Singh]

I also don't know better method but I don't see repeat function here in data lines, Try repeat function here instead of column ':' and spaces

Only(Nameoforg) & ':' & '    '&Only(StreetName) & ':'& '    '&Only(EANCode) & ':'&'    '&Only(Year) & ':'&

  right('          ' & num(sum({<Year = {2015},DataTypeID = {45},EnergyTypeID = {53},QualityScore = {">0"}>}Volume1 + Volume2), '#,##0'),10) &

  '      ' & num((sum({<Year = {2015},DataTypeID = {5},EnergyTypeID = {53},QualityScore = {">0"}>}Volume1 + Volume2)), '#,##0')&

  '      '& num((sum({<Year = {2015},DataTypeID = {45},EnergyTypeID = {53},QualityScore = {">0"},Volume1 = {">0"}>}Volume1 + Volume2)

-

sum({<Year = {2015},DataTypeID = {5},EnergyTypeID = {53},QualityScore = {">0"},Volume1 = {">0"}>}Volume1 + Volume2))/

(sum({<Year = {2015},DataTypeID = {5},EnergyTypeID = {53},QualityScore = {">0"},Volume1 = {">0"}>}Volume1 + Volume2)),'##0%')

[#5]

Ok thanks,

I will try the suggestion you gave.

[sunny_talwar]

Wow this thread is never ending it seems .

I really like the amount of patience digvijay‌ has shown here. Something to learn for all of us.

[Digvijay_Singh]

Thanks Sunny for the good words. It means a lot to me.

Thanks,

DJ

[#8]

Hi Sunny,

Digvijay its an amazing person and he is always very helpful. I really appreciate that about him and very patient too.

Thanks Digvijay I am always greatful for your help and support.

[#9]

Hi Sunny,

Digvijay its an amazing person and he is always very helpful. I really appreciate that about him and very patient too.

Thanks Digvijay I am always greatful for your help and support.

[sunny_talwar]

Awesome, I am glad you do and I agree you do

[#11]

Hi Digvijay,

Please I created a some input boxes where I enter Client name, LocID and ProjCode. Then I created a Save button that when clicked, will save the values entered in an excel table. It works fine but the problem is if I enter another client name, it replaces the previous one. Please any help on how resolve these?

Thanks.