Skip to Content
author's profile photo Former Member
Former Member

Help with formula in the pas

Dear expert !

I build the formula for calculate the score of kpi.

kf009_tardev

if kf09_act le kf09_tar =100

otherwise = (kf09_act%kf09_tar)

The formula is working very well but when kf09_act doesn't exist (empty) and kf09_tar is number the formula goes to otherwise and get the score (kf09_act%kf09_tar) and I want that score will be 100.

How can I check at formula that kf09_act is empty null?

I try this formula but it doesn't work.

if kf09_act is null =0

and try this

kf09_act is empty =0

it doesn't work at pas.

Very glad to get any help.

Best regards,

Benyamin Orit.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 20, 2015 at 12:03 PM

    Have you tried exchanginging the "is" with "EQ" ?

    PAS scripting used to have the

    LT Less Than

    GT Greater Than

    EQ EQual

    In other words, "IF kf09_act EQ NULL"

    Possibly also try to change NULL for "MISSING", but i doubt that will work.

    There's also another option in the PAS DB, try the command:

    "SET DEF MISSING '0'"

    before running the proc.

    This would normally set the output to zeros, when values are missing. We haven't really succeeded using it in the past though, but could be worth a try...

    BR,

    Hans Jacobson

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.