FORMULA RELATED ISSUE

aditya
aditya
in Modeling

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

Tagged:

Answers

  • ArunManickam
    ArunManickam

    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

  • aditya
    aditya
    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
  • ArunManickam
    ArunManickam

    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

     

     

  • aditya
    aditya

    Thank you so much Arun 

    it worked good 

    Thanks a lot

Categories