Cannot convert numeric parameter to % to use on metric

Hi Zack,

Thanks for reaching out. Could you provide screenshots or replication instructions in this case?

Thanks,

Eric

Hey Eric!

I apparently figured it out by accident....

I just had to wrap the calculation in a SUM.

Or, it decided to just randomly work.... I spent most of the afternoon trying to make this work.

Thanks anyway!

-Zack

Hi Zack,

Thanks for the reply, glad to hear another workaround has been discovered in this program!

That does seem a little odd that you'd need a a SUM here though to get a "non-zero" value... maybe its something like a field type thing.

The OTHER thing I just thought of... sometimes you can bypass the validation of the calculated field -

If Auto Detect is selected, then the system will determine the nature of the result field itself. However, if a data type is specified by the user (eg, Numeric, text, etc) then the system will not perform a validation check upon saving the calculated field.

Combined with that, I know some clients turn off the calculated field validation... but it only works for editing, it always tries to validate on creation / 1st save. You can "trick it" by just entering something like 1 the first time.

https://community.yellowfinbi.com/knowledge-base/article/turn-off-validation-of-calculated-fields-when-saving

Do you remember enabling this feature at one time? You can check the table for the entry if not. If this is enabled, maybe you "tricked" it and testing and it could still "broken," just not giving you the error haha!

Debug or SQL Server logs may yield more clues as to what's getting divided by zero with this calculation... maybe a null in mfreight or multiplier fields. Let me know if this adds up at all. Otherwise feel welcome to close if you're over this :)

Thanks,

Eric

Hi Zack,

I'm going to go ahead and mark this ticket as Completed due to inactivity at this time. Feel welcome to reach out in the future.

Thanks,

Eric