Hi,
I was trying to apply a formula to calculate the Slowmoving stocks in powerpivot datatable. Below is the formula that I used in the calculated fields area.
OBS_2M:=IF(AND([2M_Qty]=0,[Inv_Manual]>0),[Inv_Manual],0)
While checking the powerpivot file, I noticed that the column called OBS_2M, reflects a grand total as '0', at the bottom of the table. while if I scroll across the OBS_2M column, there is a value!
Can you please advise what could be the possible reasons for not seeing a grand total value.
Regards,
Arun
I was trying to apply a formula to calculate the Slowmoving stocks in powerpivot datatable. Below is the formula that I used in the calculated fields area.
OBS_2M:=IF(AND([2M_Qty]=0,[Inv_Manual]>0),[Inv_Manual],0)
While checking the powerpivot file, I noticed that the column called OBS_2M, reflects a grand total as '0', at the bottom of the table. while if I scroll across the OBS_2M column, there is a value!
Can you please advise what could be the possible reasons for not seeing a grand total value.
Regards,
Arun