not calculating depending on the dimension

[ecabanas]

Hi,

I have some orders and to calculate the freight cost I'm using this formula:

(if(carrier_id='61',if(sum(CoF)=0,'10,2',sum(CoF)*-1), //FBC

if(carrier_id='52',if(sum(CoF)=0,'9,72',sum(CoF)*-1),

if(carrier_id='88',if(sum(CoF)=0,'9,72',sum(CoF)*-1),

)))) //Celeritas)

But if I change the dimension from SalesId to Calendar_Month, the calculation did not work.

Anyone knows why?

Thank's

Eduard

[dsharmaqv]

can you post your app

[sasikanth]

Try this,

if (carrier_id='61' and sum(CoF)=0,'10,2',sum(CoF)*-1, //FBC

if(carrier_id='52' and sum(CoF)=0,'9,72',sum(CoF)*-1,

if(carrier_id='88' and sum(CoF)=0,'9,72',sum(CoF)*-1,

))) //Celeritas)