Skip to Content
0
Former Member
Feb 15, 2014 at 11:17 AM

Formula help

19 Views

Hi All,

I have a report in that i need i created a formula Varsale like this.

if {@TarSale_TimeWise}= 0 or isnull({@TarSale_TimeWise}) then '-'

else

totext(round(({@ActSale_TimeWise}-{@TarSale_TimeWise})/{@TarSale_TimeWise}*100,1),1)

Here the formula for {@TarSale_TimeWise} is

round({CatTimeWise.tarSale},1)

Similarly the formula for {@ActSale_TimeWise} is

round({CatTimeWise.ActSale},1)


why because i need to take rounding as 1 for both the fields and then i need to do the calculation for var sale with values round as 1 for both the formulas.

Now instead of creating this below 2 formulas and using those in 3rd formula I want to create only one formula using variables.

Please suggest how can i modify above formulas as 1 formula.