AnsweredAssumed Answered

Now, this calc makes no sense at all?

Question asked by DennyHayes on Jul 4, 2018
Latest reply on Jul 5, 2018 by wimdecorte

Case(

Chats::Count Of Portal Rows ≥   

Left ( Chats::Image Location ;

   Position ( Chats::Image Location ; "-" ; 0 ; 1 ) - 1 ); "Y" ; "N" ) &

 

": " &

 

Chats::Count Of Portal Rows & " " &

Left ( Chats::Image Location ;

   Position ( Chats::Image Location ; "-" ; 0 ; 1 ) - 1 )

 

The result of that calculation is "N: 11 2". Since the first section of the calc says that the first number is not larger, but the same two parts of the calc were added at the end, which shows the first part is 11, and the second part is 2. The last time I checked 11 was larger than 2 . There are really one two fields used. The Chats::Image Location field is only a static text field showing the row and repeat of an image in the form 3-4, for portal row (record) and repeat, which is updated by scripts. Chats::Count Of Portal Rows is the calc Count ( Images::Contact ID). But even if my calcs were wrong, how can two parts of the same calc using the same two calculations disagree with each other?

Attachments

Outcomes