Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 05 Apr 2018 at 8:54am
Your current formula is a row level analysis of the value of that field on that row.
If you want the sum to be highlighted use the below formula on the sum field.
if {TrainingObjectiveHistory.tohobjTitle} = "iso facility use hours" and SUM({TrainingObjectiveHistory.tohseshrs}) <18
Although I think you still have an issue because this would be the the total sum and not the sum where the row is like the "iso..." condition. If you are trying to that you need to use a conditional running total or another formula field that you would sum.
//iso_only formula
if {TrainingObjectiveHistory.tohobjTitle} = "iso facility use hours" then {TrainingObjectiveHistory.tohseshrs} else 0
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 05 Apr 2018 at 10:19am
so you want to change the font color of tohobjTitle field?
You want the field to be red when what the title value = 'iso facility use hours' and the sum of all tohseshrs < 18 or only if the sum of the tohseshrs rows where title = 'iso facility use hours' < 18?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 06 Apr 2018 at 2:34am
Create a formula field you will use to get the sum where only title = 'iso facility use hours'
call it something like "iso_facility_use_hours_only".
it will be
if {TrainingObjectiveHistory.tohobjTitle} = "iso facility use hours" then {TrainingObjectiveHistory.tohseshrs} else 0
now you will sum that formula field
for the color condition it will be
if {TrainingObjectiveHistory.tohobjTitle} = "iso facility use hours" and sum(@iso_facility_use_hours_only)<18 then CrRed else CrBlack
Or you might consider grouping on tohobjTitle and using the group level sum but that will possibly change your sort order or structure too much for whatever else the report is for.
Joined: 31 Mar 2018
Location: United States
Online Status: Offline
Posts: 7
Posted: 06 Apr 2018 at 9:02am
Not working but thank you.
The
if {TrainingObjectiveHistory.tohobjTitle} = "iso facility use hours" and sum(@iso_facility_use_hours_only)<18 then CrRed else CrBlack
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum