Focal Point
[SOLVED] HOw to use condition on percentage column.

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5377007096

August 22, 2018, 02:17 PM
Raju
[SOLVED] HOw to use condition on percentage column.
Is there anyway to use condition on percentage column like greater than or equal 80% then display like that.

AprCount (%)
------------

22.23%
82.93%
46.44%
92.99%
56.87%
89.01%
93.12%

my code is like this
TABLE FILE WAIVDB
SUM
COMPUTE REG_CNT_PCT/D6.2%= IF (HWVRGRP EQ 'Regular' OR 'Denial') THEN (REG / TOT_CNT) * 100 ELSE 0;
AS 'AprCount(%)'
BY HDOC NOPRINT

This message has been edited. Last edited by: FP Mod Chuck,
August 22, 2018, 03:08 PM
FP Mod Chuck
Raju

The WHERE TOTAL statement can be used against COMPUTED fields.


TABLE FILE WAIVDB
SUM
COMPUTE REG_CNT_PCT/D6.2%= IF (HWVRGRP EQ 'Regular' OR 'Denial') THEN (REG / TOT_CNT) * 100 ELSE 0;
AS 'AprCount(%)'
BY HDOC NOPRINT
WHERE TOTAL REG_CNT_PCT GT 80



Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
August 22, 2018, 03:47 PM
Raju
quote:
TOTAL REG_CNT_PCT GT 80


I AM GETTING BELOW ERROR

(FOC732) COMPUTED FIELDS CAN ONLY BE REFERENCED IN A WHERE TOTAL
August 22, 2018, 03:57 PM
Raju
It is working. thank you. Please ignore the above error.

How do I retrieve highest to lowest values in AprCount column.

Thank you for you help.
August 22, 2018, 04:31 PM
FP Mod Chuck

TABLE FILE WAIVDB
SUM
COMPUTE REG_CNT_PCT/D6.2%= IF (HWVRGRP EQ 'Regular' OR 'Denial') THEN (REG / TOT_CNT) * 100 ELSE 0;
AS 'AprCount(%)'
BY TOTAL HIGHEST COMPUTE REG_CNT_PCT/D6.2%= IF (HWVRGRP EQ 'Regular' OR 'Denial') THEN (REG / TOT_CNT) * 100 ELSE 0; NOPRINT
BY HDOC NOPRINT
WHERE TOTAL REG_CNT_PCT GT 80


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
August 22, 2018, 04:37 PM
Raju
I want to display HDOC and AprCount columns. My requirement is display HDOC and percentage in Aprcount which is highest to lowest.
August 22, 2018, 04:38 PM
Raju
Sort BY HDOC and highest to lowest values in AprCount
August 22, 2018, 08:46 PM
FP Mod Chuck
Take the NOPRINT off of the end of BY HDOC


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
August 23, 2018, 11:24 AM
Raju
Thank you all. It worked fine.