Error in exp

[Chanty4u]

hi,

below is my  result formulae and i used exprsn ...

( No of Defects Re-op / Total No of ref fixed ) * 100

used exp:  =num(Def_Status='Reop')/sum(if(ref='Open' or ref='New' or ref='Assigned', 0,1))*100

it shwng exprn Ok... but pie chrt values or not getting.. 

Error message:no data to dispaly

please help me the expression

Thanks in advance

Suresh

[Anonymous]

Does your expression contains -ve values??

FYI, Pie chart never represent -ve Values..

[Chanty4u]

yeah..jagan...

this is the final exp

with i hve multiple field names

(count({<Def_status={"Reopen"}>} Def_Status) / count({<Def_Status-={"Open","New","Assigned"}>} Def_Status) )*100

it is shwng Exp ok. bu values no exposing i need in pie chart as %?

[Chanty4u]

yes..but i dont hve  to disply -ve values...

[tamilarasu]

Hi Suresh,

Can you post your application.?

[Anonymous]

try this:

=num(

count({<Def_Status={'Reop'}>} DimensionField)   //may use Distinct as well

/

sum(if(ref='Open' or ref='New' or ref='Assigned', 0,1))

,'#')*100

or

Where do you want to multiply with 100, if it is with sum() then like this

=num(

count({<Def_Status={'Reop'}>} DimensionField)   //may use Distinct as well

/

sum(if(ref='Open' or ref='New' or ref='Assigned', 0,1))*100

,'#')

[Anonymous]

Then put condition like in your expression:

=if(sum(sales)>0, sum(sales))  where sum(sales) is your expression

[jagan]

Hi Suresh,

Give this expression

(count({<Def_status={"Reopen"}>} Def_Status) / count({<Def_Status-={"Open","New","Assigned"}>} Def_Status) )

and in number tab select percentage option.

Note: Pie chart won't display negative values, if you have negative values then you have filter it out like below

If((count({<Def_status={"Reopen"}>} Def_Status) / count({<Def_Status-={"Open","New","Assigned"}>} Def_Status) ) > 0,

(count({<Def_status={"Reopen"}>} Def_Status) / count({<Def_Status-={"Open","New","Assigned"}>} Def_Status) ))

Hope this helps you.

Regards,

Jagan.