Display sum of boolean field with positive numbers

Comments

• AlexTZ

  October 2004 edited 7:10AM

  If you want to do the conditional summing, use the scripts and calculate the sum yourself.
• BrentForbes

  October 2004 edited 7:10AM

  So in other words, I've lost some functionality by upgrading to FR3.x.
  In version 2.5x the code I used below provided me with exacly what I needed. I cannot do that with version 3.x. In fact the code generator in 2.5x wrote most of the code.
  
  [SUM([AdsQuery1."Married"]=TRUE)]
  _____________________________________
  
  Could you post an example script? I believe that would be more helpful than just saying you need to write scripts.
  
  Thanks,
  Brent
• AlexTZ

  October 2004 edited 7:10AM

  If you try to convert True to integer, you'll get -1. FR does the same. Just do:
  [ABS(<SUM(<frxDBDataset1."Married">,MasterData1,1)>)]
  
• BrentForbes

  October 2004 edited 7:10AM

  Thank you very much! That did the trick. By the way, what is "ABS"?
  
  Brent
• gordk St.Catherines On. Canada.

  October 2004 edited 7:10AM

  same as in delphi function to return absolute value no signs.