I have a report where i am getting totals from a database.
im trying to wright a formula that will change the price value of
{tvwr_Quotes.DetailTotalSellingPrice} to a 0 if word sniff val is greater than 0.00.
this is what i have so far
if {@word sniff} > 0.00 then {tvwr_Quotes.DetailTotalSellingPrice} = Val ("0")
Cheers
thanks for your answer
so i would be looking at a formula like
if {@word sniff} > 0.00 then {tvwr_Quotes.TotalNetSell} -{tvwr_Quotes.PrintLineItemPrices};
Do you think this would be correct.
the only other thing is i have the totals being made in the subreport and the value of {@word sniff} formula is not there
can i link this in some way?
Add a comment