Forum Discussion

kca's avatar
kca
Regular Visitor
6 years ago

Add daily fixed cost to table

Hi   I dynamicaly get cost data from Azure that have multiple rows per day with various products/cost.  Now I want to add the cost of a 3.part product that we pay monthly (e.g. 300$), so i can use...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

kca , Create a date table with

 

Date = calendar(Date(2020,1,1),Today())

Avg Cost = 10 //new column

kca's avatar
kca
Regular Visitor
6 years ago

Thanks.

What if I have multiple rows to add per day? like

ProductA 10$

ProductB 5$