[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 NOPRINTThis 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