if with sum caused an issue

[kishorj1982]

Hi All,

I am using below expression

if(Dimensionality()=0,$(vInvTurnsCalc)/$(vDivide),(sum(Cogs_Value_USD)*-1)/If((Divide/12), vBasePrice,((vBasePrice+Sum(InventoryValue_USD))/2))/(Divide/12)*12)

where

vBasePrice=Sum({<Month_Turns = {'Jun'}>}InventoryValue_USD)

it seems that sum within if causing issue.

Data is not displayed in table properly it is showing 0.00 after applying number formatting.

When I can remove the number formatting it is showing as excepted.

Please suggest.

Can you please suggest what would be expression for this .

Thanks.

[kishorj1982]

sry man but this did not work f9.not getting the exact results.

[kishorj1982]

Hi All,

Can you please suggest on this.

Thanks

[Anil_Babu_Samineni]

I haven't suggested anything here. Not sure what you mean by "not getting the exact results"