Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
can anyone explain what the following expression when it's being multiplied by -1 means?
Inmonth() - returns true(-1) or false(0). Multiplying it with -1, means it returns 1 if true else 0. Hence, for your case - if TempDate belongs to the same month as today then 1 else 0. So it's basically being used for flagging, perhaps in a calendar or date in fact table.
Inmonth() - returns true(-1) or false(0). Multiplying it with -1, means it returns 1 if true else 0. Hence, for your case - if TempDate belongs to the same month as today then 1 else 0. So it's basically being used for flagging, perhaps in a calendar or date in fact table.