# Search Results

Search results 1-6 of 6.

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

• ### Split year into months.

jdalby - - Rules

Post

Hi, as a starting Point i create an attribute on the year "MonthFormula" - which contains the "list" value. So 2020 has "2020-01', '2020-02', '2020-03', '2020-04', '2020-05', '2020-06', '2020-07', '2020-08', '2020-09', '2020-10', '2020-11', '2020-12" as month formula. Then i can create a Query formula, which returns attribute (2020-01', '2020-02', '2020-03', '2020-04', '2020-05', '2020-06', '2020-07', '2020-08', '2020-09', '2020-10', '2020-11', '2020-12) on left side and uses element (2020) on r…

• ### Split year into months.

jdalby - - Rules

Post

Hi, a simple problem, which I can not solve.. I have yearly numbers from year 2021 to 2090 - and i need to split them into months (1/12) for each year. The only solution i have now is to hardcode rules with constant - so the rule looks like this: ['Measure':'Amount Month', , 'Time':{'2021-01', '2021-02', '2021-03', '2021-04','2021-05', '2021-06', '2021-07', '2021-08','2021-09', '2021-10', '2021-11', '2021-12'}] = B:([ 'Measure':'Amount Year', 'Time':'2021', ] / 12) But then I have to create 70 r…

• ### Use Concatenate for writing dimension ID

jdalby - - Rules

Post

Hi, a simple problem, which i can not solve with the right syntax... I need to copy from one dimension ID to another dimension ID. My TARGET dimension ID is same as SOURCE dimension ID - but with "_XXX" at the end. For example with logic ['Product':'Laptop_XXX'] = ['Product':'Laptop'] My target is same dimension ID as my target - but with "_XXX" concenated at the end. So i am looking for a syntax like: ['Product':concatenate("'", !'Product', "_XXX'"] = ['Product':'Laptop']. But i can not find th…

• ### Rules with IF AND and IF OR

jdalby - - Rules

Post

Hi, i am struggling with finding the right syntax for using rule formulaes with IF AND / IF OR. So for example What is syntax for; 1) IF AND : IF !'Product' == "Car" AND !'Color' == "Green" THEN xxxx ELSE yyyy 2) IF OR : IF !'Product' == "Bicycle" OR !'Color' = "Blue" THEN xxxx ELSE yyyy Thank you, Joergen Dalby

• ### Calculate present value of future value

jdalby - - Rules

Post

Hi, it worked with the power formula. Thank you. Then my next challenge is how to deduct to 2 dimension value from each other So i have "Base Year", which is the year the budget is done. So if the budget is done for 2020 - base year is 2020. Then the budget is multiple years - which is "Time". So time is 2020, 2021, 2022, 2023 etc. The "Power" is the difference between "Time"-"Base Year". Power = "Time"-"Base Year". So the power is 0 in 2020 (2020-2020) and power is one in 2021 (2021-2020). Rega…

• ### Calculate present value of future value

jdalby - - Rules

Post

Hi, I need to do a business rule on a model for calculating a measure (amount) from present value (including inflation) to present value (excluding inflation). It has to be a rule on the model. I can't really find any support for this. The formula is fairly simple : PV = FV/(1+R)n PV = present value FV = future value R = Inflation n = number of years (so if a value is 5 years from now - n is 5) The problem is the "raised to the power". Here the is a formula EXP(number) - which is support in rule…