11 Replies Latest reply: Dec 16, 2016 8:58 AM by bruno bertels RSS

    Conditional Calculation

    denis Brennan

      Here is the problem.


      Good morning. I have a fact table containing daily and hourly electricity consumption. In Excel (pre load) I added a column DayNIght with values of "Day or Night" dependent upon the timestamp - so a flag. I want to multiply Consumption by the correct rate in a related dimension table dependent upon the value of the flag. The relationships are fine but I can't get the conditional logic to work either with 'If" or Set Analysis. Can someone help, please?