Calc formula max length?

[limpet]

Hey everyone,
What's the maximum length for the formula of a calc measure? I think I went past that. I'm having to do a switch statement of 15 measures resulting in a formula 683 characters long.

Sure would be nice if you could write something like

Code: Select all

MeasureX = (measurea || measureb || measurec) ? %1 : "False statement"

where %1 would be the value that matches MeasureX.

Anyway, yeah, anyone have suggestions for a way to break down my formula?

[JamesAC]

There is a maximum of 9 of these nested conditional statements.

Kenz0 posted a good solution here.

[limpet]

Yeah, I was starting to figure out the same conclusions.

I ended up breaking up my calc into 3 parts using a similar method in that post. It's a pain because I'm using it for my new calendar and so I have to do those 3 calculations for each of the 42 days that are showing for the current month.

I think it would be possible to slim it down to 2 calculations but I'll get to that after the skin is fully working and ready for optimizations.

Thanks for the help.