Aggr and Set analysis

[linoyel]

Hey,

I have the following expression in the table:

Sum (if(cctranzresponse=000,Sum,0)) / Sum(aggr(Max(First_Try_Amount),unique_num,Department,UpType,IsOnline))

Now I need to write the same expression but for the certain bookmark and country.

I tried this:

Sum ({AppRate * 1<BillingCountryKey = {191}>} if(cctranzresponse=000,Sum,0)) /

Sum({AppRate * 1<BillingCountryKey = {191}>} aggr(Max(First_Try_Amount),unique_num,Department,UpType,IsOnline))

This works only when BillingCountry 191 is selected, but I want the expression not to be dependent on user selections...

[MK_QSL]

Sum ({1<BillingCountryKey = {191}>} if(cctranzresponse=000,Sum,0)) *AppRate /

Sum({1<BillingCountryKey = {191}>} aggr(Max(First_Try_Amount),unique_num,Department,UpType,IsOnline))*AppRate

Or

Sum ({1<BillingCountryKey = {191}>} if(cctranzresponse=000,Sum*AppRate ,0)) /

Sum({1<BillingCountryKey = {191}>} AppRate*aggr(Max(First_Try_Amount),unique_num,Department,UpType,IsOnline))

[linoyel]

Hi Manish, in both of your answers AppRate isn't recognized, probably it's location is the expression in incorrect...

[MK_QSL]

Can you upload your sample file or sample data?

[linoyel]

I don't know how to upload file...

[linoyel · Accepted solution]

Well, I figured it out

This worked:

Sum({AppRate * 1<BillingCountryKey = {191}>} if(cctranzresponse=000,Sum,0)) /

Sum({AppRate * 1<BillingCountryKey = {191}>}aggr(Max({AppRate * 1<BillingCountryKey = {191}>} (First_Try_Amount)),unique_num,Department,UpType,IsOnline))

[MK_QSL]

Use advanced editor... and add your file as an attachment...

Advance Editor option is available at the TOP RIGHT...

[linoyel]

Use advanced editor where? What is advanced editor?

[MK_QSL]

If you try to reply, you will find the screen where usually we write... search there.

[linoyel]

Oh, I see! Thank you!

So uploading file is called "binary upload"? Or "binary upload" is something else?