Reg: Webi4.0 Formula From Bex

[Former Member]

Hi,

Am trying to write the below mentioned formula in BO webi but am getting in correct values in the report.

Formula in BEX:

Formula i wrote in BO Webi:

If([Total Order Value (incl. Tax)]=0;0;(([Total Order Value (incl. Tax)]-([Invoiced Value (excl. tax)]+[Tax (Inv)]))/[Total Order Value (incl. Tax)])*100)

showing formula is correct when i parse but am getting in correct results in the report.

Kindly help me in this regard.

Thanks & Regards,

Kumar

[carlos_pintocamarero · Accepted solution]

Hi Kumar,

I think it is

If([Total Order Value (incl. Tax)]=0;0;([Total Order Value (incl. Tax)]-([Invoiced Value (excl. tax)]+[Tax (Inv)])/[Total Order Value (incl. Tax)])*100)

isn't it?

Regards,

Carlos

[Former Member · Accepted solution]

Many thanks Carlos now am getting the correct values.

Thanks & Regards,

Kumar

[carlos_pintocamarero · Accepted solution]

Hi Kumar,

I'm glad I could help you!

Best regards,

Carlos