Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Null value in formula

  1. #1
    Join Date
    Sep 2016
    Posts
    23

    Default Null value in formula

    hi..i have some problem

    i have a boolean field on my database. this field has value [true or false AND NULL]

    in my formula...
    i create like this..

    =IF([includeppn]= TRUE();([totalQtyXprice]-[totalDariDiskonPerRow])*(100/110);IF([includeppn]=NULL();[totalQtyXprice]-[totalDariDiskonPerRow];[totalQtyXprice]-[totalDariDiskonPerRow]))

    its look like Boolean type cannot read as NULL



  2. #2
    Join Date
    Aug 2016
    Posts
    142

    Default

    Perhaps put a conditional statement in your source query so that it outputs these as 1,2,3 etc?

  3. #3
    Join Date
    Nov 2009
    Posts
    688

    Default

    When you want to check for a null value you can use ISBLANK. So the formula is then

    =IF([includeppn]= TRUE();([totalQtyXprice]-[totalDariDiskonPerRow])*(100/110);
    IF(ISBLANK([includeppn]);[totalQtyXprice]-[totalDariDiskonPerRow];[totalQtyXprice]-[totalDariDiskonPerRow]))

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.