Calculated item divided by number of days in a month

1029635

Hello.

I'm trying to create a calculated item, that is supposed to represent a column member, divided by the number of days in a month that's selected from the dashboard prompt.

I know that I need an SQL function to get the number of days, but I don't think that you can use SQL functions when creating calculated items.

Is there a way to do this?

SriniVEERAVALLI

Looks like you are thinking too much

Use expression builder in the rpd and then just use available functions without 2nd thought.

if helps mark