FORMULA RELATED ISSUE

Highlighted
Occasional Contributor

FORMULA RELATED ISSUE

hello community,

 

i have a lineitem Has Data? which is a boolean format   and in the same module i have product and store dimensions 

i want to write a formula in such a way that if a store has a particular product then the corresponding boolean box has to be checked 

please help me with a resolution

sai.formula related issue.PNG

4 REPLIES 4
Highlighted
Community Boss

Re: FORMULA RELATED ISSUE

Hello @aditya 

 

What is the line item that determines the store has the product or not. Do you have historical sales?

 

Assuming, you have historical sales number in this module, it will be like 

 

Historical sales > 0

 

Thanks

Arun

Highlighted
Occasional Contributor

Re: FORMULA RELATED ISSUE

thnks for responding arun
but here i have historic volumes and jus tried as per ur advice but it is checking all the boxes
and the hint given is to use time sum and if condition
Thanks
Highlighted
Community Boss

Re: FORMULA RELATED ISSUE

Hello Aditya,

 

TIMESUM(<<Historical volumes>>) > 0

 

Replace Historical volumes with a line item that you have in your module which has the historical volume data.

 

Thanks

Arun

 

 

Highlighted
Occasional Contributor

Re: FORMULA RELATED ISSUE

Thank you so much Arun 

it worked good 

Thanks a lot