Rank() function question

[#1]

Hi all,

This is my issue:

I Have an "Exception" table with the following dimensions : App, Advertiser and Campaign ID.

I would like to add as an expression the "Main Partner", meaning the partner who has the largest value of revenue.

I'm using the following expression:

but in the result, I see only "-".

Can you help?>

Thank you!

Ella

[richard]

Looks like you're missing the $ after "sum(..."

[tresesco]

Remove the outer If and include the condition in the set analysis part like:

=If(Rank(Sum({<Exception type={'Positive 1 STD Exception'}, isYesterdayDate= .....

[MK_QSL]

=IF(Aggr(Rank(SUM({<IsYesterdayDate = {1},PartnerReport = {'PartnerReport'}, [Exception Type] = {'Positive 1 STD Exception'}>}(ClickCost + InstallCost))/100),partner_name)<2, partner_name)

[#5]

Hi All,

The sum should not include the "[Exception Type]" part.

It is a calculated expression in that table, and I would like to get the "Partner" field to appear only if the Exception type equals to what is written above.

In any case, why would an "if" inside of an "if" create problems?

[tresesco]

Could you post your app with sample data?

[#7]

Please post sample qvw with data & reproduce the issue.

[#8]

Hi All,

As Thank you for your answers..

Please see the QVW here: https://drive.google.com/file/d/0B4dVjL8rcPOCb0tmOVFrUTVMX00/edit?usp=sharing

I am trying to get a value under "Campaign STD Limited" tab, under "1 std Positive exception" table, and under "Main Partner column".

Can you please advise?

Thank you!

Ella

[#9]

Please see mt QVW at the bottom

[#10]

Please see mt QVW at the bottom