3019269000

[afelya]

I am using 8.5,
The percent field on a pie chart comes from devision of 2 fields. I have no problems getting the percent.
Now i need to do the same thing on a pie chart but this time the formula counts the projects. I can get chart to show the oppurtunities as a count and i can show the total count of the opportunities but when it comes to show th percent i am having a hard time. Formula i wrote shows the count if i do count {@dur} or {@durwin} but can not get the count of the percent when i do the devision. ANy ideas???


Percent formula => {@sumdurwin} / {@totalduration}

Durwin formula => Local numbervar x;
if {STATUS.DESCRIPTION} in ["Won"] then
(if {BID_SUBJ.DURATION} = 0.00 then x:= ({BID_SUBJ.EST_NET_REVENUE_AMT} )
else
x:= Tonumber({BID_SUBJ.EST_NET_REVENUE_AMT} / {BID_SUBJ.DURATION}))

duration formula => Local numbervar x;
if ({BID_SUBJ.DURATION} = 0.00 or isnull({BID_SUBJ.DURATION})) then x:= ({BID_SUBJ.EST_NET_REVENUE_AMT} )
else
x:= Tonumber({BID_SUBJ.EST_NET_REVENUE_AMT} / {BID_SUBJ.DURATION})