This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have been stuck at some calculations I need to do with columns based on "mmyyyy" combination and keep on updating. So the calculation needs to be dynamic to handle the column header change.
I need to do different calculations. I was able to solve it when the dynamic columns were similar(mmyyyy format). Attaching the sample workflow for your reference
But now there is another column which needs to be handled ( format - "Licmmyyyy")
Calculations are as below -
1. "Upgrade" AS Metric ,IIf(->0 And <>0 And [Lic202001]>[Lic201912],-,0) AS 202001 2. "Pricing" AS Metric ,IIf(->0 And <>0 And [Lic202001]<=[Lic201912],-,0) AS 202001
Any help on how to approach this would be really helpful.