Builing Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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 !!
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access General Date Forced To Have Date And Time 2
expression builder sum total not entering into table but showing o 1
Format dollars in formula 2
Formula Problem 2
How do I make into a dollar format when in a formula? 2
Aggregate Function Error 0
Trouble with VBA loop 5
summing two columns of different data 4

Back
Top