14087 IIf expression
Sign Up |  Live StatsLive Stats    Articles 37,332| Comments 177,275| Members 19,415, Newest GP Kaur| Online 734
Home Contact
 (Forgotten?): 
    Sikhism
    For best SPN experience, use Firefox Internet Browser!


                                                                   Your Banner Here!    




Click Here to Register/Sign Up Daily Hukamnama Member Blogs Downloads Website Navigation Help Fonts Tags

IIf expression

Our Donation Goal : Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters
Goal this month: 500 USD, Received: 115 USD (23%)
Please Donate...
     
Related Topics...
Thread Thread Starter Forum Replies Last Post
Null expression??? MartinR Information Technology 2 28-Jul-2006 08:34 AM
Help with This Expression Levans digital Information Technology 2 28-Jul-2006 08:10 AM
Checkbox with a IIF expression. GILBERT Information Technology 4 28-Jul-2006 08:02 AM
IIf Expression Levans digital Information Technology 6 28-Jul-2006 08:02 AM
Using the Value of a variable in an expression Bob W Information Technology 2 09-Nov-2005 17:51 PM


Tags
iif, expression
Reply Post New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!
  #1 (permalink)  
Old 28-Jul-2006, 08:15 AM
Xjcinhoustonx's Avatar Xjcinhoustonx
Guest
 
Posts: n/a
   
   
IIf expression

  Donate Today!   Email to Friend  Tell a Friend   Show Printable Version  Print   Contact sikhphilosophy.net Administraion for any Suggestions, Ideas, Feedback.  Feedback  

Register to Remove Advertisements
I have an expression for choosing whether to pay a commission stated as:

35 DN Bonus: IIf([Dnpmt Perc Of Total]>=0.35 And [Dnpmt Perc Of
Total]<1,[35% Down Bonus]![Total35% DN Bonus],0),
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10670-iif-expression.html

This works fine unless the total in the [Total 35% Dn Bonus] field is 0,
then it just returns a blank. How can I fix this problem

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10670


*







Got anything to share on This Topic? Why not share your immediate thoughts/reaction with us! Login Now! or Sign Up Today! to share your views... Gurfateh!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 28-Jul-2006, 08:15 AM
KARL DEWEY's Avatar KARL DEWEY
Guest
 
Posts: n/a
   
   
RE: IIf expression

Try this --
35 DN Bonus: IIf([Dnpmt Perc Of Total]>=0.35 And [Dnpmt Perc Of
Total]<1,IIF([35% Down Bonus]![Total35% DN Bonus] Is Null, 0,[35% Down
Bonus]![Total35% DN Bonus]),0)


"Xjcinhoustonx" wrote:

> I have an expression for choosing whether to pay a commission stated as:
>
> 35 DN Bonus: IIf([Dnpmt Perc Of Total]>=0.35 And [Dnpmt Perc Of
> Total]<1,[35% Down Bonus]![Total35% DN Bonus],0),
>
> This works fine unless the total in the [Total 35% Dn Bonus] field is 0,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10670
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10670
> then it just returns a blank. How can I fix this problem
>
>

Reply With Quote
  #3 (permalink)  
Old 28-Jul-2006, 08:15 AM
Xjcinhoustonx's Avatar Xjcinhoustonx
Guest
 
Posts: n/a
   
   
RE: IIf expression

  Donate Today!  
I tried it and it returns all zeros. There is actually data that it needs to
return too.

"KARL DEWEY" wrote:

> Try this --
> 35 DN Bonus: IIf([Dnpmt Perc Of Total]>=0.35 And [Dnpmt Perc Of
> Total]<1,IIF([35% Down Bonus]![Total35% DN Bonus] Is Null, 0,[35% Down
> Bonus]![Total35% DN Bonus]),0)
>
>
> "Xjcinhoustonx" wrote:
>
> > I have an expression for choosing whether to pay a commission stated as:
> >
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10670
> > 35 DN Bonus: IIf([Dnpmt Perc Of Total]>=0.35 And [Dnpmt Perc Of
> > Total]<1,[35% Down Bonus]![Total35% DN Bonus],0),
> >
> > This works fine unless the total in the [Total 35% Dn Bonus] field is 0,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10670
> > then it just returns a blank. How can I fix this problem
> >
> >

Reply With Quote
   Click Here to Donate Now!

Support Us!
Become a Promoter!
Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh!
ReplyPost New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!

Bookmarks


(View-All Members who have read this thread : 0
There are no names to display.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Tools Search
Search:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

» Active Discussions
Occultism - Rejection in...
Today 22:22 PM
60 Replies, 2,593 Views
Woolwich Killing: The...
Today 22:09 PM
1 Replies, 2 Views
How does Sikhi help you...
Today 21:36 PM
30 Replies, 951 Views
Kirtan
Today 21:24 PM
0 Replies, 8 Views
Panjabi
Today 21:22 PM
15 Replies, 293 Views
Keeping Amrit Vela
Today 16:49 PM
12 Replies, 924 Views
Do you believe in...
Today 15:08 PM
196 Replies, 4,096 Views
Black Sikhs?
Today 06:33 AM
20 Replies, 5,839 Views
Man Driving Without...
Today 05:06 AM
5 Replies, 142 Views
Request for assistance...
Today 04:24 AM
8 Replies, 91 Views
Losing My Religion: Why...
Today 03:03 AM
13 Replies, 350 Views
Health Exercise And...
Today 02:10 AM
1 Replies, 94 Views
Sikh Spokesman (ਪੰਜਾਬੀ...
Today 02:10 AM
176 Replies, 4,513 Views
How Religions Change...
Today 02:07 AM
1 Replies, 108 Views
Rozana Reports (ਪੰਜਾਬੀ...
Today 01:52 AM
313 Replies, 7,609 Views
» Books You Should Read...
Powered by vBadvanced CMPS v3.2.3
All times are GMT +6.5. The time now is 22:57 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2 Copyright © 2004-12, All Rights Reserved. Sikh Philosophy Network


Page generated in 0.36674 seconds with 32 queries
0