oh i see. i did not know sunday is day 1 dayoftheweek (in OBI). i would expect sunday is 7 but now i get you

i just reviewed your formula -> everything makes sense but not the last two statements. should be like this? when 6 then TIMESTAMPADD(SQL_TSI_DAY,4, "Dim - Period"."Start Date") when 7 then TIMESTAMPADD(SQL_TSI_DAY, 3, "Dim - Period"."Start Date") else "Dim - Period"."Start Date" end

apologies, as working days, i mean weekdays (monday to friday) Doug, you are right , i just want to exclude weekends when adding days to a date

Thanks Adam You advice fixes the problem. However, i am trying to make to work the aggregate function located in the calculation console but i can not figure out why it does work

Good links, I will keep it for future. 

Hi it does not work with country code. You need to upload another file into the project containing the country code in one column and the full country name in other. Afterward you have to link the first file with the second using the country code. Once this is done, drag into the graph the full country name from the second…

it works !!! it is quite tricky to do it but I will keep it on mind.

Hello, I have still problems because the information is displayed without following the rule added in the calculation called test1 is there any alternative solution?

Hi Delivered, shipped and WIP are values in the same column , so i could not follow your steps. Finally, i found the solution by creating three different calculations using conditions and the attribute containing the values: This way i created the following calculations: - shipped - calculation - delivered - calculation -…

Hi all i just forgot to cast as double the numerator and do the same for the denominator cast ( as double)/ cast ( as double) now it is fixed