Webi question – formula needed for exception handling

[shannonlp]

Hi,

I created a variable where the formula is

=Sum(MonthsBetween(Min([Timesheet Start Date]);Max([Timesheet End Date])))

This works as expected but there are instances where it returns 0. If it returns 0 I need 1 displayed. I’m not sure how to add this syntax in my variable (if 0, then 1).

Any guidance would be greatly appreciated.

I'm on BOE 3.1 SP6 FP 6.4.

 

[SkipVought]

If YourFormula = 0 then 1 else YourFormula

 

[shannonlp]

Great - thanks!