Forum Discussion
RPNancy54
3 years agoHelper I
Roundup 0,05
Hello, Someone can help me please ? Roundup to 0,05 ??? What the mesure ? Thanks
RPNancy54
3 years agoHelper I
Greg_Deckler
3 years agoCommunity Champion
RPNancy54 If I translated that correctly it says that the arguments for the GENERATESERIES function cannot be empty. Do you have a blank row for your Mesure somewhere? If that is the case, you could wrap the whole thing in an IF statement where you check if Mesure is blank (ISBLANK() or [Mesure] = BLANK() ) and if so just return a 0. Or you could just use a +0 like this:
VAR __Table = ADDCOLUMNS(GENERATESERIES([Column1] + 0,[Column1]+.05,.01),"Mod",[Value] - 0.05*INT([Value]/.05))