Logic Help in opportunity caliculaton?

[ganeshreddy]

Hi All,

PFA QVW, I have two sheets in the attached QVW, Sheet1 report is giving the correct results and I am unable to get the totals of Sheet1 report to the  sheet2 report . At the moment the sheet2 report has the incorrect results for Total GWP of opportunity and current participation. Please help me to get the desired output I am struggling since last few days to get the results, please suggest me any new expressions or steps to make the logic in the script. Help will be much appreciated.

The expected output should be like below.

But current output is like below

Thanks,

Ganesh

[ganeshreddy]

Hi tresesco‌,

Is there any work around that I can do to achieve the desired results as I showed in the previous replay, Please suggest.

Thanks,

Ganesh

[Anil_Babu_Samineni]

For Total GWP, Try this?

Sum({<TransType={'T'}>} TOTAL GrossWrittenPremium_GBP)

Total GWP of Opportunity - Can you explain the logic?

[ieuyar]

Try below expression on Total GWP:

$(=Sum({<TransType={'T'}, MarketName=>}GrossWrittenPremium_GBP))