avg in two subreport

[majidsoft]

hi
i do your advise but i face with error can you send me a sample
thanks

[Alex K.]

Hello,

Please see the attached report sample.

Thank you.

[majidsoft]

hi
thanks for your attention
my field in my main report is take avg from to variable but i want if on of them have 0 value avg not working and show another number this is my problem
now if any of them face with 0 avg in my main report use it in formula that i dont want it to do that
thanks

[Alex K.]

Hello,

You can use following expression:

Code: Select all

avg={IIF((Avg1==0)||(Avg2==0),"No avg",(Avg1+Avg2)/2)}

Thank you.

[majidsoft]

hi
thank you but my problem not solved i write my code in programming language please you change it for me
thanks
if avg1=0 or avg2=0 then
if avg1=0 then
avg=avg2
else if avg2=0 then
avg=avg1
end if
else
avg=(avg1+avg2)/2
end if

[Alex K.]

Hello,

Code: Select all

avg = {IIF((Avg1==0)||(Avg2==0),(IIF(Avg1==0,Avg2,(IIF(Avg2==0,Avg1,0)))),(Avg1+Avg2)/2)}

Thank you.

[majidsoft]

hi
its so beautiful code
thank you

[Andrew]

We are always glad to help you!