Skip to main content
Solved

Little help on changing field type within a formula column

  • July 16, 2019
  • 2 replies
  • 21 views
Y

Hy Guys,

We’re trying to do a formula in order to create a new graph within our dahsboard. However it keeps telling us that:
=> Y-axis field “Pourcentage_retard” is not numeric

The formula that we’re using is:
=> IF(nb_intervention=0, “0”, inter_retard/nb_intervention)

I’m wondering if a need to add a formula to switch to numeric.

Thanks in advance!

Best answer by Yan_de_Paula

is inter_retard/nb_intervention a single field or two?

  1. You need to add {} around field names.
  2. I do NOT know if a slash is allowed in field names. (I bet it is.)
  3. if inter_retard is text (not a field name), it should be “inter_retard”&{nb_intervention}
    Good luck!

Hello ! Thanks for your help. Actually I found it. I put a string around 0 => “0”. By taking of it, now it’s ok.

IF(nb_intervention>0,inter_retard/nb_intervention,0)

Cheers.

2 replies

W
Forum|alt.badge.img
  • WIN_ACRC
  • Known Participant
  • July 16, 2019

is inter_retard/nb_intervention a single field or two?

  1. You need to add {} around field names.
  2. I do NOT know if a slash is allowed in field names. (I bet it is.)
  3. if inter_retard is text (not a field name), it should be “inter_retard”&{nb_intervention}
    Good luck!
Y
  • Yan_de_Paula
  • Author
  • New Participant
  • Answer
  • July 18, 2019

is inter_retard/nb_intervention a single field or two?

  1. You need to add {} around field names.
  2. I do NOT know if a slash is allowed in field names. (I bet it is.)
  3. if inter_retard is text (not a field name), it should be “inter_retard”&{nb_intervention}
    Good luck!

Hello ! Thanks for your help. Actually I found it. I put a string around 0 => “0”. By taking of it, now it’s ok.

IF(nb_intervention>0,inter_retard/nb_intervention,0)

Cheers.

Terms & ConditionsAccessibility statement