Skip to Content
0
Former Member
Nov 01, 2013 at 09:05 AM

Reg: Webi4.0 Formula From Bex

17 Views

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

Attachments

pastedImage_0.png (93.6 kB)
pastedImage_5.png (34.9 kB)