How to allocate values after null entries check using data action

[azm_azm]

Hi,

There is a scenario where the values needs to be allocated from brand to SKU level. Example, I have sales of USD 1200 and it needs to be allocated down to SKU level based on actual SKU details. I'm able to write the allocation logic for this scenario. The issue when there are no SKU and the value needs to be allocated to dummy SKU. Please refer below screenshot.

As per the above example, I'm facing issue in Scenario 2 because I'm unable to check for NULL records for SKU and writing back the data to dummy SKU. Now this dummy SKU is specific to Brand. If brand is Dove, then dummy SKU would be Dove_Dummy and if the brand is Vivel then dummy SKU would be Vivel_Dummy. Anyone who has faced this similar kind of issue or knows the workaround in this case. Their comments would be deeply appreciated.

Thanks.

[N1kh1l · Accepted solution]

@azm_azm 

As SAC Advance formula works on fact data mode handling the dummy sku can be tough but you could do it this way. First always assign the value to the dummy sku and then later post your allocation logic put an IF condition logic that if sum of all skus is not null then delete the dummy sku posting.

As per your example, Write 1200 first to both Dove_dummy and Vivel_dummy. Then in Dove case put an if logic of sku1+2+3 is not null delete dove dummy but for vivel this if check will not quaslify and vivel dummy posting will stay as is.

Hope this helps

Nikhil