Suppress group based on Max formula 1

[RenaG]

Hi,

I have created two formulas:
@DecreasedAppetiteFlg
If FldA = 123 then
'N'
Else If FldA = 543 then
'Y';
@MaxAppetiteFlg
Maximum ({@DecreasedAppetiteFlg}, Dt_Tm})
(NOTE: rpt is grouped on Dt_Tm)

I am trying to suppress the group footer when @MaxAppetiteFlg is blank or null. But this code isn't working:
{@MaxAppetiteFlg} = "" or {@MaxAppetiteFlg} = " "

Any other suggestions? TIA!

 

[kray4660]

Have you tried ISNULL({@MaxAppetitFlg})?

 

[RenaG]

I hadn't but just did and it didn't work either.

Thanks for the suggestion!

 

[lbass]

..@DecreasedAppetiteFlg

if isnull(FldA) then
"" else
If FldA = 123 then
'N' Else
If FldA = 543 then
'Y'

Then suppress using:

{@MaxAppetiteFlg} = ""

-LB

 

[RenaG]

Perfect!!! That is exactly what I needed.

You are so clever.

Thank you!