Forum Discussion
Failure with calculating subcategory sum
Hi, I am trying to calculate a value sum for a subcategory. There is a relationship on item ID from table OBSOLETE to table ITEMS. ART_GROUP_OBS_VALUE_NEW = CALCULATE(SUM(XXBI_OBSOLETE_ITEMS...
Hi Anonymous,
Maybe you can try to use following formula calculate summary value based on current subcategory:
ART_GROUP_VALUE_NEW = CALCULATE ( SUM ( XXBI_OBSOLETE_ITEMS_V[GROSS_VALUE_NEW] ), VALUES ( XXBI_ITEMS_MV[WEIR_OP_ARTICLE_GROUP_NAME] ) )If above not help, can you please share some sample data for test?
Regards,
Xiaoxin Sheng
Hi Anonymous,
Maybe you can try to use following formula calculate summary value based on current subcategory:
ART_GROUP_VALUE_NEW =
CALCULATE (
SUM ( XXBI_OBSOLETE_ITEMS_V[GROSS_VALUE_NEW] ),
VALUES ( XXBI_ITEMS_MV[WEIR_OP_ARTICLE_GROUP_NAME] )
)
If above not help, can you please share some sample data for test?
Regards,
Xiaoxin Sheng