Format Value within iif statement

[alecgreen]

Hi

I have this formula - Margin%: IIf([value]=0,"****",([Value]-
[StdCost])/[Value]*100), and I want to format the result (if not zero)
to 2 decimal points.

Mant Thanks

Alec

 

[pietlinden]

Hi

I have this formula - Margin%: IIf([value]=0,"****",([Value]-
[StdCost])/[Value]*100), and I want to format the result (if not zero)
to 2 decimal points.

Mant Thanks

Alec

use the Format function inside your expression.

 

[alecgreen]

Hi

I have this formula - Margin%: IIf([value]=0,"****",([Value]-
[StdCost])/[Value]*100), and I want to format the result (if not zero)
to 2 decimal points.

Mant Thanks

Alec

use the Format function inside your expression.

not sure how to do this, could you explain further please!

 

[Dennis]

Margin%: IIf([value]=0,"****",Format(([Value]-[StdCost])/[Value]*100,"0.00"))

Hi

I have this formula - Margin%: IIf([value]=0,"****",([Value]-
[StdCost])/[Value]*100), and I want to format the result (if not zero)
to 2 decimal points.

Mant Thanks

Alec

use the Format function inside your expression.

not sure how to do this, could you explain further please!

 

[alecgreen]

Margin%: IIf([value]=0,"****",Format(([Value]-[StdCost])/[Value]*100,"0.00"))

Hi
I have this formula - Margin%: IIf([value]=0,"****",([Value]-
[StdCost])/[Value]*100), and I want to format the result (if not zero)
to 2 decimal points.
Mant Thanks
Alec
use the Format function inside your expression.

not sure how to do this, could you explain further please!- Hide quoted text -

- Show quoted text -

Thanks for that, works a treat!