Zero value is getting displayed in brackets? Could you please help to solve this, Since I have written a condition like, If (value=0, Green, Red)

[#1]

[arulsettu · Accepted solution]

try this

if(value='0',green(),red())

[sushil353]

Hi,

Try this:

if(Fabs(Diff)>0,Green(),Red())

[awhitfield]

Hi Anees,

could it be that the value is actually negative and rounded to zero, and the number format mask applied has negative is brackets? e.g.  #.##0,00; (#.##0,00)

HTH - Andy

[#5]

nop it did'nt worked

[#6]

But I want it when it is = to zero. then how come >

[#7]

Yep, But when i created in another table it is showing like below:

[MayilVahanan]

Hi

Try like this

Ceil(ur expression)

i.e. Ceil(A-B)

Hope it helps

[#9]

Yeah it worked, Thanks a bunch.

But will it effect my further development, if I have 179999.997?

it will be giving only 179999 ryt?

[MayilVahanan]

Hi,

Then you can go for Round() or Floor() function.