Sorry I posted as Guest
but am licensed user

scott@vendormax.com.au
Should I repost?

I also try to create advanced conditional format and it never "sticks" either

Here are my columns

I have made all Null to Zero

there are some zeros in calcs as denominator but would expect formatting to cope with this?




thanks

Hi Scott,

So sorry for the long delay!

I've run a few tests in the latest 7.1 using a union subquery, calc field and then applying conditional formats to that calc field.

However, in each case, the conditional format is displayed and never removes.

Are you able to provide some detailed info as to how the report is built?
Also, which browser and release of Yellowfin are you using?

I created a calc field using the Ski Team Tutorial DB:
Sum (Invoiced Amount)/Sum (Invoiced Estimate) . I then created a conditional format based o this field.

Please let me know if I'm missing anything.

Regards,
David

we decided to add data from Query rather than inside YF

thanks

will provide if we see issue again