Skip to Content
0
Feb 19, 2014 at 12:48 PM

Transformation formula getting error

17 Views

Hi ALL,

i have to write some formula ta transformation level but is not working. i am facing always syntax errors.

please look at the data

sample data

TypeCategoryunitsMax UnitsFixed Charge (Rs/HP/Month)Demand Charge (Rs/kVA/Month)Energy Charge (Rs/unit)LTLT1Slab 1 (0-50)501.45LTLT1Slab 2 (51-100)1002.8LTLT1Slab 3 (101-200)2003.05LTLT1Slab 4 (201-300)3004.75LTLT1Slab 5 (>300)3015.5LTLT2Slab 1 (0-50)503.85LTLT2Slab 2 (51-100)1006.2LTLT2Slab 3 (>100)1016.5

here consumer type have only LT and category have different (LT1,LT2,LT3) and different slabs (0-50, 51-100, 101-200,201-300, above 300)

my requirement is

if type is LT and if category is LT1 and slab is ( 0-50) = charge 1.45

if type is LT and if category is LT1 and slab is ( 51- 100) = charge 2.8

if i write the formula or routine is best performance please suggest.

Thanks,

Phani.