2 Differents Conditions Rows in Reports

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

2 Differents Conditions Rows in Reports

Postby FilS2BotS » Tue Oct 05, 2010 9:23 am

How can i put 2 differente conditions for the Rows in the "Advanced" of "Report"
I tried ",", "AND", "OR", " ", " 'Enter' " between the 2 conditions and the report become all red in Rows...
I mean like in stats when you put news conditions for colours you just creat a new line more... So what is the was in "Advanced" in "Reports" ???
TY
FilS2BotS
 
Posts: 149
Joined: Wed May 05, 2010 2:20 am

Re: 2 Differents Conditions Rows in Reports

Postby kraada » Tue Oct 05, 2010 1:16 pm

Advanced is mostly for coloring and dealing with the summary line.

If you want to filter for specific situations in reports you can do that in the Filters section - AND should work there. What conditions are you trying to use?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 2 Differents Conditions Rows in Reports

Postby FilS2BotS » Tue Oct 05, 2010 2:21 pm

if(amt_bb_won <0,rgb(255,236,236),rgb(255,255,255))
if(amt_bb_won >0,rgb(231,255,231),rgb(255,255,255))
both of them in Advanced to colour the Rows
TY
FilS2BotS
 
Posts: 149
Joined: Wed May 05, 2010 2:20 am

Re: 2 Differents Conditions Rows in Reports

Postby kraada » Tue Oct 05, 2010 5:24 pm

Use instead:

if(amt_bb_won <0,rgb(255,236,236),if(amount_bb_won >0, rgb(231,255,231), rgb(255,255,255))
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests