Builing Formula

C

carolini

Hi Everyone,

This is what I'm trying to do: convert the following formula into an if
statment

%Collected of Net Issued: (Sum([q_Collected-Issued]![Total Dollars
Collected]))/[q_Collected-Issued_MonthlyNetDollarsIss]![sumofNet Dollars
Issued]

Where if the SumofTotalDollarsCollected is 0 I want the result column (%of
Collected of Net Issued) to show 0

Can anyone help me please. Thanks!!
 
W

Wayne-I-M

Collected of Net Issued:IIf ( Sum ( [q_Collected-Issued]![Total Dollars
Collected] / [q_Collected-Issued_MonthlyNetDollarsIss]![sumofNet Dollars
Issued]] )>0 , 0, Sum ( [q_Collected-Issued]![Total Dollars
Collected] / [q_Collected-Issued_MonthlyNetDollarsIss]![sumofNet Dollars
Issued]] ))


You need to look at the names of your fields as some could do with altering !!
 
C

carolini

Thank you so much!!

Wayne-I-M said:
Collected of Net Issued:IIf ( Sum ( [q_Collected-Issued]![Total Dollars
Collected] / [q_Collected-Issued_MonthlyNetDollarsIss]![sumofNet Dollars
Issued]] )>0 , 0, Sum ( [q_Collected-Issued]![Total Dollars
Collected] / [q_Collected-Issued_MonthlyNetDollarsIss]![sumofNet Dollars
Issued]] ))


You need to look at the names of your fields as some could do with altering !!



--
Wayne
Manchester, England.



carolini said:
Hi Everyone,

This is what I'm trying to do: convert the following formula into an if
statment

%Collected of Net Issued: (Sum([q_Collected-Issued]![Total Dollars
Collected]))/[q_Collected-Issued_MonthlyNetDollarsIss]![sumofNet Dollars
Issued]

Where if the SumofTotalDollarsCollected is 0 I want the result column (%of
Collected of Net Issued) to show 0

Can anyone help me please. Thanks!!
Click to expand...
Click to expand...
 
Top