if statement Plus Count

Question

I have two columns:Actual&nbsp;Planned&nbsp; &nbsp;CountTheRowP1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1P2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1P3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1P4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1I would normally use something like this:if(isnum(Actual),1,if(isnum(Planned),1))&nbsp;So if P1 has either a Planned or an Actual amount - the row is counted,&nbsp;Also: wh is it so hard to type into this section?&nbsp; Tab and returns are odd???Jo

amitchandak · Answer

Anonymous , Create a new column like
if(not(isblank([Actual])) || not(isblank([Planned])),1,0)

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;You could doIF( NOT( ISBLANK( [Actual] ) ) || NOT( ISBLANK( [Planned] ) ) ,1 ,0)

anonymous · Answer

Thank you - this is very strange - I am translated into Spanish?  And I cannot press tab or enter ... I think it is because I am the opposite part of the globe? Already

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Every post here is translated from english to spanish and vis-a-varsa.Your post is also in english. Click the icon&nbsp;on top right of this window you will see both posts. Right now there is no way to switch of spanish.

amitchandak · Answer

Anonymous , you will get both the English and Spanish messages. just check the correct ticket in your profile.

Forum Discussion

if statement Plus Count

7 Replies

Related content

Counting nulls

OR Statement ?

SQL Statement opcion error

Count Of Drivers

Support for MERGE statement