Formula Help Needed, If Then Else?

Hi all,

I'm looking for help on a formula.

if {SO_Detail.Price} <> than the original price then show {SO_Detail.Product} else suppress duplicate {SO_Detail.Product}

For example, when the column to the right (price) changes I want the number on the left (Product) to repeat, otherwise stay suppressed:



Edited by belfane - 30 Aug 2016 at 5:11am

Make sure to set the suppression formula to use default values for nulls and try

table.rightfield = previous(table.rightfield) and table.leftfield = previous(table.leftfield)