Help on expression

[ganeshreddy]

Hi All,

Please find attached QVW, how to get the correct current participation values in attached file, here current participation value should always be higher than market share, the values for current participation are incorrect in the present straight table.

I have tried the substringcount function instead of possible values but it didn't work.

Help will be much appreciated,

Thanks,

Ganesh

[ganeshreddy]

Hi stalwar1‌ ,

Please help me on this, was unable get knowledge from you yesterday.

Thanks,

Ganesh

[sunny_talwar]

Lets break it down to this

Sum( {<POLICYMARKET-=p(MarketName)>} [GrossWrittenPremium_GBP])

What is the expected output here

[ganeshreddy]

Hi Sunny,

That has to be the market opportunity value i.e.

Mock exp:

Sum( {<POLICYMARKET<>MarketName)>} [GrossWrittenPremium_GBP])

FYI  exclude the matched values of POLICYMARKET string and MarketName values in the summation.

ex :  POLICYMARKET= Abu|Aca|Adv  (0r)  Aca|Adv|Abu|Abu

        MarketName = Abu

        Exclude the MarkrtName value matched rows to POLICYMARKET strings and provide total GWP_GBP opportunity value.

Thanks,

Ganesh

[ganeshreddy]

Hi Jyotish,

I realized now, Yes,you are correct, In the data there are no entries which satisfy the given condition.

I am not sure how to calculate, please help me to calculate opportunity value. basically i.e

Exclude the 'MarkrtName' value matched rows to 'POLICYMARKET' strings to get total GWP_GBP opportunity value.

PF my recent reply to Sunny for given example.

Kind Regards,

Ganesh

[sunny_talwar]

I am afraid, I am not understanding this in words, can you tell me the numbers you would see with the expression like this?

Sum( {<POLICYMARKET<>MarketName)>} [GrossWrittenPremium_GBP])

[jyothish8807]

Hi Ganesh,

I think the solution suggested by me should work for you.

if(Column(1) <> 0 and TransType='T',

(Sum({<MarketName=>}  GrossWrittenPremium_GBP)-sum(if(index('|' & [POLICYMARKET] & '|', '|' & MarketName & '|') = 0, [GrossWrittenPremium_GBP])))/Sum({<MarketName=>} GrossWrittenPremium_GBP),0)

You can check this by manupulating your excel file.

Br,

KC