Hi all, having an issue. I’m working on a quote design that will amortize the cost of a product over ‘X’ amount of years. Like this --
However, we only want the calculation to appear for the product and not the separate charges like setup, freight etc. (fields highlighted yellow should not print)
Should the VisibleExpr be something like
=IIf( (InStr( [QuotePricing.TemplateInventoryID], 'APF-PGC')>0, False, True)
Basically, what I’m trying to say is IF InventoryID = ‘APF-PGC’, then don’t print this cell; otherwise, print the cell. The other issue is there are probably have a dozen InventoryIDs where I will have to say if it equals this OR equals this OR equals this etc, then don’t print cell, else go ahead and print.
Using the above, I’m getting a syntax error… help!
Best answer by hkabiri
View original