Forum Discussion

warrencowan's avatar
warrencowan
Icon for Kudo Collector rankKudo Collector
11 years ago
Solved

Need help creating date delta columns

I have a value in a column, eg (visits), and in another column I have the (date). I also have 3 rows for each date, because I have 3 different stores (StoreID) with a vlaue for visits   I want to b...
  • andre's avatar
    andre
    11 years ago

    you may also take a look at lookupvalue() function ...

andre's avatar
andre
Icon for Memorable Member rankMemorable Member
11 years ago

you may also take a look at lookupvalue() function ...

warrencowan's avatar
warrencowan
Icon for Kudo Collector rankKudo Collector
11 years ago

Thanks Andre. I have experiemnted with this, but I think the last criteria in the lookup query has to be a non column item.

 

So I can't lookup [visits] where [date] is (datediff [date] -7) for example.

 

Any thoughts how to work around that?

  • andre's avatar
    andre
    Icon for Memorable Member rankMemorable Member
    11 years ago

    Can you add a different column and populate it with logic in such a way that it helps you get the lookupavlue() function to work?